Grab the first word of a cell — a first name, a product code, a command. LEFT up to the first space does it; a trick handles single-word cells too.
A2 & " ") avoids an error when there’s no space.
The example
The first word pulled from a phrase.
| A | B | |
|---|---|---|
| 1 | Text | First word |
| 2 | Ann Marie Lee | Ann |
| 3 | Solo | Solo |
The formula
Everything up to the first space:
How it works
FIND the space, LEFT the rest:
FIND(" ", A2)returns the position of the first space.LEFT(A2, position - 1)returns the characters before it — the first word.- The trick:
A2 & " "appends a space so FIND always finds one, even in a single-word cell (which then returns the whole word). - In Excel 365,
TEXTBEFORE(A2, " ")is the clean modern version.
365 shortcut: =TEXTBEFORE(A2, " ", 1, , , A2) returns the first word and defaults to the whole string if there’s no space — no concatenation trick needed.
Try it: interactive demo
Type text; get the first word.
Variations
365 version
Clean:
First two words
Up to the 2nd space:
After trimming
Handle leading spaces:
Pitfalls & errors
No space = error. Plain FIND errors on a single-word cell. The A2 & " " trick (or IFERROR) avoids it.
Leading spaces. A space at the start makes the “first word” empty — TRIM first.
Other delimiters. If words are separated by commas or tabs, FIND that character instead of a space.
Practice workbook
Frequently asked questions
How do I extract the first word in Excel?
Why does FIND error on single-word cells?
What's the Excel 365 way?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class