Get First Word in Excel (2026) — LEFT + FIND Formula Generator
Returns the first word in a text string.
How to Get the First Word from a String
Extracting the first word is often used to get a person's First Name from a full name column.
The Logic
We use a combination of LEFT and FIND functions:
- FIND(" ", A2): This tells us the position number of the first space character.
- LEFT(A2, Position - 1): This extracts everything from the left up to (but not including) that space.
Edge Case: Single Words
Note: If the cell contains only one word (no spaces), this formula might return an error. You can wrap it in IFERROR to handle single-word cells gracefully.
Common Errors & Fixes
#VALUE! when extracting first word
Causes:- No space in the cell (single word).
- FIND returns error when space is missing.
- Empty cell.
Fixes:- Use IFERROR: =IFERROR(LEFT(A2,FIND(" ",A2&" ")-1),A2) to treat one word as the whole cell.
- Or use TEXTBEFORE in Excel 365 / Sheets when supported.
Frequently Asked Questions
How do I get the first word in Excel?
Use LEFT with FIND on the first space: =LEFT(A2,FIND(" ",A2)-1). For Google Sheets you can also use TEXTBEFORE when available.
Why do I get #VALUE when extracting the first word?
Usually there is no space in the cell (single word) or the cell is empty. Wrap with IFERROR or test with IF(ISERROR(FIND(...))).
How is this different from PROPER or TRIM?
PROPER capitalizes words; TRIM removes extra spaces. LEFT+FIND returns only the substring before the first space.
Want to become an Excel Pro?
Stop searching for formulas. Master Excel in 30 days with this top-rated course.
Learn More