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")
The following screenshot shows how to use this formula in practice:
Note that you can also return a different value by simply replacing “No space” with some other value in the IFERROR() function.
Additional Resources
The following tutorials explain how to perform other common tasks in Google Sheets:
Google Sheets: Check if Cell Contains Text from List
Google Sheets: How to COUNTIF Not Equal to Text
Google Sheets: Conditional Formatting if Another Cell Contains Text
