Extract left before first space in Excel and Google Sheets

=LEFT(A2,(FIND(" ",A2,1)-1))

A2 = data cell; " " = criteria (space)

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Extract left before first space in Excel

How to extract a text before space in a string in Excel?
EXTRACT LEFT BEFORE SPACE — EXCEL FORMULA

EXTRACT LEFT BEFORE FIRST SPACE — EXCEL FORMULA AND EXAMPLE

=LEFT(A2,(FIND(" ",A2,1)-1))

  • A2 = data cell

  • " " = criteria (space)

This formula will extract any value before the first space and is most suitable for a text string containing two words. For example, first and last name. You can change the space (" ") to your criteria in the above formula

Extract left before first space in Google Sheets

How to extract a text before space in a string in Google Sheets?
EXTRACT LEFT BEFORE SPACE — GOOGLE SHEETS FORMULA

EXTRACT LEFT BEFORE FIRST SPACE — GOOGLE SHEETS FORMULA AND EXAMPLE

=LEFT(A2,(FIND(" ",A2,1)-1))

  • A2 = data cell

  • " " = criteria (space)

This formula will extract any value before the first space and is most suitable for a text string containing two words. For example, first and last name. You can change the space (" ") to your criteria in the above formula

Other useful extract formulas in Excel and Google Sheets explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions