How to Get First Word from Cell in Excel (3 Formulas Compared)

Extracting the first word from a cell is a common task when cleaning data, such as separating first names from full names or product categories from SKUs. Here are the three best ways to do it in Excel.

Method 1: The Classic LEFT & FIND Formula

This is the most compatible method and works in all versions of Excel (and Google Sheets).

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

How it works:

• FIND(" ", A2) locates the position of the first space.
• -1 ensures we don't include the space itself.
• LEFT(A2, ...) extracts that number of characters from the start.

Method 2: The "One-Word Proof" Formula (Recommended)

The basic formula above will return a #VALUE! error if the cell contains only one word (because there is no space to find). Use IFERROR to fix this:

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

If no space is found, IFERROR simply returns the original text in A2.

Method 3: Excel 365 — TEXTBEFORE (Cleanest)

If you are using Microsoft 365 or Excel 2024, there is a much simpler function designed specifically for this:

=TEXTBEFORE(A2, " ")

This does exactly what it says: it returns all text before the specified delimiter (the space). If you want it to handle single words without an error, add the optional arguments:

=TEXTBEFORE(A2, " ", , , , A2)

Comparison Summary

Requirement	Best Formula
Maximum Compatibility	=LEFT(A2, FIND(" ", A2)-1)
Handles Single Words	=IFERROR(...) Version
Simplicity (Excel 365)	=TEXTBEFORE(A2, " ")

Need more help with text? Try our Split Text Tool or our LEFT Formula Generator.