Table of Contents
Google Sheets is a powerful spreadsheet tool that allows you to perform complex calculations, create dynamic charts and graphs, and more. In this tutorial, we will explore how to use the LEFT function in Google Sheets to extract text before a space. By the end of this tutorial, you will know how to use the LEFT function in Google Sheets to extract text before a space, and how to use the LEFT function to extract a specific number of characters from a cell. Let’s get started!
You can use the following formula with the LEFT and FIND function to extract all of the text before a space is encountered in some cell in Google Sheets:
=LEFT(A2, FIND(" ", A2)-1)
This particular formula extracts all of the text in cell A2 that occurs before the first space is encountered.
The following example shows how to use this formula in practice.
Example: Using LEFT to Extract Text Before Space
Suppose we have the following list in Google Sheets that provides a brief description of different basketball players including their team, position, and ranking:
Now suppose that we would like to extract only the team name for each player.
To do so, we can use the following formula with the LEFT and FIND functions in Google Sheets to extract the text from the left side of each cell until a space is encountered:
=LEFT(A2, FIND(" ", A2)-1)
We can type this formula into cell B2 and then click and drag this formula down to each remaining cell in column B:
Column B now displays only the team name for each player in column A.
It’s worth noting that if no space is found in the Player Description column, the formula will return #VALUE! as a result.
To return a different value, simply use the IFERROR() function.
For example, we can use the following IFERROR() function to return “No space” if a space is not found in a given player description:
=IFERROR(LEFT(A2, FIND(" ", A2)-1), "No space")
Note that you can also return a different value by simply replacing “No space” with some other value in the IFERROR() function.