To extract the first word from a cell in Excel, enter =LEFT(TRIM(A2),FIND(" ",TRIM(A2)&" ")-1) in an empty cell, replacing A2 with the cell that contains your text. The formula returns everything before the first space, removes extra spaces at the beginning or end, and works even when the cell contains only one word. You can then fill the formula down to handle other rows.
What You’ll Need
- An Excel workbook with the text you want to split, such as full names or product descriptions, in a column.
- An empty column where Excel can display the extracted words. Keeping the original text in place lets you check the results and change the formula later.
- Microsoft Excel for Microsoft 365 on Windows. The main formula also works in many earlier Excel versions. An optional TEXTBEFORE method later in this guide requires Microsoft 365 or Excel 2024.
No add-in or special setting is required. The examples below assume the source text starts in A2 and that row 1 contains a heading. If your data is in a different place, use the corresponding cell reference instead.
Step-by-Step
- Identify the source and output columns. Find the column containing your text. For example, if A1 is headed Full Name and A2 contains Maya Chen, choose an empty cell in another column, such as B2. Avoid placing the result over the source, because doing so could replace text you still need.
- Enter the formula for the first row. With text in A2 and the result going in B2, click B2 and type
=LEFT(TRIM(A2),FIND(" ",TRIM(A2)&" ")-1). Press Enter. The result for Maya Chen is Maya. The formula takes the text to the left of the first space after TRIM removes extra spaces at the beginning and end. - Check a few different kinds of entries. If A2 contains Harbor, the result is Harbor even though there is no space. If A2 contains North Ridge, with two spaces between the words, the result is North. If the source cell is blank, the formula returns a blank result. These checks help confirm that the formula matches your data before you copy it.
- Copy the formula to the other rows. Select B2 and point to the small square at its lower-right corner, called the fill handle. Drag it down through the rows that contain source text. Excel adjusts the reference automatically: the next row uses A3, then A4, and so on. You can also copy B2 with Ctrl+C, select the destination cells, and press Ctrl+V. On Mac, use Command+C and Command+V instead of Ctrl+C and Ctrl+V.
- Review the filled results. Compare a sample of the new values with the original text, especially rows with one-word entries, multiple spaces, or blank cells. Make sure you copied the formula to the last intended row and did not include unrelated data beneath the list. If the result in one row is wrong, inspect that source cell for unusual spacing or punctuation.
- Keep formulas or turn the results into fixed text. Leave the formulas in place if you expect the source text to change and want the extracted word to update automatically. If you need a static list, select the result cells, copy them, then use Home > Paste > Paste Values. This replaces the formulas with their displayed results. Check that the values look right before saving, because the formula will no longer update if the original text changes.
- Save the workbook. Press Ctrl+S on Windows or Command+S on Mac. If you need to share the file with someone who may edit the source text, keeping the formulas is often more useful. If you are sending a final list that should not change, values may be more convenient.
The formula uses three functions. TRIM removes leading and trailing regular spaces and reduces repeated spaces between words to one. FIND locates the first space; adding a space after the cleaned text ensures FIND still has a space to locate when the entry is a single word. LEFT returns the characters before that position. The final minus one stops the returned text just before the delimiter.
If your data starts in another cell, replace every instance of A2 in the formula with that cell reference. For example, with text in C5 and the answer in D5, the formula should refer to C5. When you fill down, Excel changes a relative reference such as A2 to A3 automatically. You do not need to edit the formula row by row.
For a shorter option, Microsoft 365 and Excel 2024 also support TEXTBEFORE. With the source text in A2 and the answer in B2, enter =IFERROR(TEXTBEFORE(TRIM(A2)," "),TRIM(A2)) in B2. It returns the text before the first space, and IFERROR returns the trimmed entry itself when no space exists. The main LEFT and FIND formula is a useful choice when you want compatibility with older Excel versions.
Common Mistakes
- Using the wrong cell reference. If the source is in A2 but the formula points to A1, Excel will return the heading or an unrelated value. Check the reference inside the parentheses, and make sure it points to the row you want to process.
- Leaving out TRIM. A basic formula may return an empty result when the source begins with a space, because Excel sees that first character as the delimiter. TRIM in the recommended formula handles ordinary leading spaces and repeated spaces between words.
- Expecting the result to include punctuation or a second word. The formula returns characters before the first space; it does not decide whether punctuation belongs with a word. For example, “Hello, there” returns “Hello,” including the comma. If you want to remove punctuation too, that requires an additional cleanup step.
- Overwriting the original cells. Entering the formula in the same cell as its source can destroy the data or create a circular reference. Put the result in an unused column, check it, and only then decide whether to replace the originals.
- Using a formula that your Excel version does not support. TEXTBEFORE is available in Microsoft 365 and Excel 2024, but not every older release. If Excel reports an unknown function for TEXTBEFORE, use the LEFT and FIND formula instead.
Tips
- Use a clear heading for the output. Label the new column First Word or First Name, depending on what the text represents. A clear label makes it easier to understand the result when filtering, sorting, or sharing the workbook. Use First Name only when the source actually contains names in that order.
- Format the results as values when needed. Formulas are useful for a changing list, while pasted values are useful for a fixed export. If you choose Home > Paste > Paste Values, keep a copy of the original data or save a separate workbook if you may need to rebuild the results.
- Use an Excel table for a growing list. If you format your data as a table with Insert > Table, entering a formula in the first row of a new table column will usually fill that calculated column automatically. Confirm that the formula reaches all existing rows, and check how it behaves when you add new records.
- Be aware of what counts as a space. TRIM handles standard spaces, but text copied from a website or another system can contain a nonbreaking space that looks identical. If a formula does not split where expected, look for the cleanup option in Troubleshooting.
- Keep a backup before making bulk changes. The formula itself does not alter the source column, which makes it a safe way to check results. However, replacing formulas with values or deleting the original column is harder to reverse after closing the workbook.
Troubleshooting
The formula appears as text instead of calculating. Check whether the cell is formatted as Text. Select the cell, choose Home > Number Format > General, then press F2 and Enter to make Excel interpret the entry as a formula. Also check that the formula starts with an equals sign and that Show Formulas is not turned on. In Windows, Ctrl+` toggles formula display; on a Mac, the shortcut can vary by keyboard, so check the Formulas tab for Show Formulas.
Excel shows a formula error or rejects the commas. Some regional settings use semicolons rather than commas between function arguments. If Excel marks the commas as invalid, replace the argument separators with semicolons, while keeping the quoted space character unchanged. If you see #NAME? with TEXTBEFORE, your version may not support that function; switch to the LEFT and FIND formula.
The output is blank even though the source looks like it starts with a word. The source may begin with a nonbreaking space copied from a webpage. With the text in A2 and the result in B2, try =LEFT(TRIM(SUBSTITUTE(A2,CHAR(160)," ")),FIND(" ",TRIM(SUBSTITUTE(A2,CHAR(160)," "))&" ")-1). SUBSTITUTE changes nonbreaking spaces, represented by CHAR(160), into standard spaces before the formula extracts the word. Check the output against the original because imported text can contain other invisible characters too.
Only the first row has a result. The formula does not automatically fill an ordinary range unless you copy it. Drag the fill handle down or copy the formula into the remaining output cells. If the fill handle is difficult to see, select the formula cell and use copy and paste on the required range.
The answer includes unexpected characters. Look for hyphens, commas, apostrophes, or other punctuation attached to the first word. The formula preserves those characters because they occur before the first space. It also splits only at a standard space; a tab or line break is not necessarily treated as the same delimiter. Clean or replace those characters first if your data requires a different definition of “word.”
The formula is correct but the output does not change. If you converted the results to values, they are no longer linked to the source. Re-enter the formula if you want a live result. If you kept formulas, check that Excel calculation is set to Automatic under Formulas > Calculation Options, and confirm that you edited the source cell the formula references.
Frequently Asked Questions
Can Excel extract the first word without a formula?
You can use Text to Columns, but it splits the source into separate columns rather than returning only the first word in a formula-linked result column. For a repeatable extraction that preserves the original text, use the formula above.
Does the formula work if a cell contains just one word?
Yes. Appending a space inside FIND gives it a delimiter to locate even when the source has no spaces. The returned result is the complete word, after TRIM removes ordinary leading or trailing spaces.
Will it work with full names that have middle names?
Yes. It returns only the text before the first space. For example, “Avery Jordan Lee” returns “Avery.” It does not identify which part of a name is legally or culturally a first name, so check your data conventions before labeling the output First Name.
Can I extract the first word from a cell that contains a sentence?
Yes. The formula returns the characters before the first regular space, so “Check the latest report” returns “Check.” Punctuation attached before that space remains in the result, as in “Wait!” from “Wait! Stop.”
What if words are separated by a tab instead of a space?
The recommended formula searches for a standard space, not every possible separator. If the data uses tabs or line breaks, replace those characters with spaces before extracting, or adapt the formula to find the delimiter actually present. First confirm which character is in the cell, because imported text can look like ordinary spacing while containing a different character.
Can I use this formula in Excel for the web or on Mac?
The LEFT, FIND, TRIM, SUBSTITUTE, and CHAR functions used here are available in Excel for the web and Excel for Mac as well as Excel for Microsoft 365 on Windows. The ribbon layout can differ slightly by platform, but the formula and fill-handle approach are the same. On Mac, use Command instead of Ctrl for the copy, paste, and save shortcuts mentioned above.
Related
- How to Enable an Audit Trail in Excel: Track Changes
- Freeze Panes in Excel: How to Edit Rows and Columns
- How to Edit Custom Number Formats in Excel Step by Step
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel: How to Hide Columns to the Right of Your DataTo hide every column to the right of your data in Excel for Microsoft 365 on Windows, select…
- Excel Formula for Name Arrangement: Sort Names A to ZFor Microsoft 365, use =SORT(A2:A20) to arrange a list of names alphabetically; replace the range with your own.…
- How to Show Formulas in Excel for MacTo show formulas in Excel for Mac, open the worksheet and choose Formulas > Show Formulas. You can…
- Excel Timesheet Formulas for Overtime, Breaks, and PayFor a basic Excel timesheet, put a shift’s start time in B2, end time in C2, and unpaid…
- Excel Named Range Not Appearing in Formula? FixesIf an Excel named range is not appearing as you type a formula, first confirm that the name…
- How to Tell If Your Excel File Is Corrupted: Key SignsYou can suspect an Excel file is corrupted if Excel cannot open it, displays a repair warning, or…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.