Function Problems

How to Extract the First Two Names Using FIND and LEFT in Excel

Muhammad Talha Sep 27, 2026 869 views

Question details

The user wants to extract the first word or the first two words (e.g., first and middle names) from a text string containing multiple words.

How to Extract the First Two Names Using FIND and LEFT in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Cleaning or splitting text data, specifically isolating names based on the spaces between words.
Observed behavior: The user needs to successfully isolate the first or first two words from a cell string without including trailing spaces.

Before you start

Check your source text to ensure words are separated by a single, consistent space character, as double spaces or missing spaces can cause these formulas to return an error.

Solution 1Recommended

Extract the First Name Using LEFT and FIND

Use a combination of LEFT and FIND to dynamically extract the first word up to the first space.

The LEFT function extracts a specified number of characters from the start of a string. By using FIND to locate the first space and subtracting 1, you can accurately extract the first word without leaving a trailing space.

Select a destination cell

Click on an empty cell next to the text string you want to extract from (for example, if your text is in A3, click B3).

Enter the formula

Type the formula =LEFT(A3,FIND(" ",A3)-1) into the formula bar.

Apply the formula

Press Enter to see the extracted first name. You can then drag the fill handle down to apply this formula to other cells.

Extract the First Name Using LEFT and FIND

Formula limitation: If a cell contains only one word and no spaces, this formula will return a #VALUE! error.

Solution 2

Extract the First Two Names Using Nested FIND

Extract two words (such as a first and middle name) by nesting a second FIND function to locate the second space in the string.

Solution 3

Extract Names Using the TEXTBEFORE Function

In newer versions of Excel, you can bypass complex nested formulas by using the TEXTBEFORE function.

Free Spreadsheet Tool

Easily Extract Text in WPS Spreadsheet

WPS Spreadsheet is fully compatible with Microsoft Excel formulas like LEFT, FIND, and RIGHT. You can easily process, split, and clean large datasets of names for free.

1. Open your data in WPS Spreadsheet: Launch WPS Office and open your spreadsheet containing the names you want to split.
2. Enter the text extraction formula: Select a blank cell and enter =LEFT(A3,FIND(" ",A3)-1) or your preferred text formula.
3. Apply to multiple rows: Press Enter, then click and drag the fill handle at the bottom-right of the cell to extract names for the entire list.

Fully supports LEFT, FIND, and other advanced text formulas.Seamlessly opens, edits, and saves Microsoft Excel (.xlsx) formats.Built-in 'Text to Columns' tools for easy data splitting without formulas.Free, lightweight, and features a familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my LEFT and FIND formula return a #VALUE! error?

A #VALUE! error usually occurs if the FIND function cannot locate a space in the cell. This happens if the cell contains only one word (no spaces) or if there are invisible non-breaking spaces instead of regular spaces.

Can I split names into columns without using formulas?

Yes. You can use the 'Text to Columns' feature. Select the column containing your names, go to the Data tab on the ribbon, click 'Text to Columns', choose 'Delimited', and select 'Space' as your delimiter to automatically split the names into separate columns.

How do I extract the last name instead of the first name?

To extract the last name (everything after the first space), you can use the RIGHT and LEN functions together: =RIGHT(A3,LEN(A3)-FIND(" ",A3)). In newer versions of Excel, you can also use =TEXTAFTER(A3," ").

Excel & Data Problems