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 first space in Excel
EXTRACT LEFT BEFORE FIRST SPACE — EXCEL FORMULA AND EXAMPLE
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 first space in Google Sheets
EXTRACT LEFT BEFORE FIRST SPACE — GOOGLE SHEETS FORMULA AND EXAMPLE
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 explained
- Extract right after first space
- Extract the nth words in a text string
- Extract domain URL from a link
- Extract URL domain root
- Flip the first and last name
- Get the last non-empty cell in a column
- Get the first non-empty cell in a column
- Extract text inside characters (parentheses)
- Get text between colons in Google Sheets
- Get text between comma in Google Sheets
- Sum by month
- SUMIF cells if contains part of a text string
- Sum total sales based on quantity & price
- Combine date and time
- Convert 1-12 to month name
- Dynamic current date and time
- Count blank cell
- Count cell between two values
- Combine two or more cell
- Extract left before first space
- SUMIF formulas and example
- SUMIFS formulas and example
- COUNTIF formulas and example
- IF formulas and example
- TEXT formulas and example
- CONVERT formulas and example
- Change the negative number to zero
- Change negative to positive numbers
- Calculate percentage changes for containing zero or negative values
- Convert date to text
- Convert time to text
- Convert weekday string to number
- Combine two or more cells with a line break
- Combine two or more cells and transpose
- Count cells over 10 characters
- Count cells that are not blank
- Count if cells contain a specific text
- Count cells that begin with a specific text
- COUNTIF based on multiple criteria