What is the Excel formula to get the first word?

=LEFT(A2, FIND(" ", A2)-1). This extracts everything before the first space.

How do I handle cells that only contain one word?

Use =IFERROR(LEFT(A2, FIND(" ", A2)-1), A2). If no space is found, it returns the whole cell.

What is the easiest way in Excel 365?

Use =TEXTBEFORE(A2, " "). It is the most modern and readable method.

Excel Formula to Get First Word from Cell (3 Easy Ways)

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.