Log in
x
or
x
x
Register
x

or
0
0
0
s2smodern

How to extract first or first two words from text strings in Google sheet?

If you need to extract the first or first two or n words from a list of text strings as following screenshot shown in Google sheet, how could you achieve it as quickly as you want?

Extract the first word from text strings in Google sheet

Extract the first two or n words from text strings in Google sheet


Extract the first word from text strings in Google sheet


To extract only the first word from a list of text strings, please apply the following simple formula.

Enter this formula: =LEFT(A2,FIND(" ",A2)-1) into a blank cell where you want to locate the result, press Enter key to get the result from A2, then drag the fill handle down to the cells which you want to extract the first word, see screenshot:


Extract the first two or n words from text strings in Google sheet

If you need to extract the first 2 or 3 or n words from the text strings, you should use the below formula.

For extracting the first two words, please enter this formula: =regexextract(A2,"[\w]* [\w]*") into a blank cell, and press Enter key, the first two words of Cell A2 will be displayed, then drag the fill handle down to the cells to extract the first two words from the list of text strings, see screenshot:

Note: To extract the first three words, you should apply this formula: =regexextract(A2,"[\w]* [\w]* [\w]*"), to extract first n words, you just need to add [\w]* n times in the formula.


Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.