Yup Me
Reputation: 1
Extract the first four words from a sentence
Given a sentence, for example:
The quick brown fox jumped over the lazy dog
what Excel formula would extract the first four words?:
The quick brown fox
Upvotes: 1
Views: 1055
Answers (1)
pnuts
Reputation: 59485
Please try:
=LEFT(SUBSTITUTE(A1," ","|",4),FIND("|",(SUBSTITUTE(A1," ","|",4)))-1)
Upvotes: 2
Related Questions
- Extract sentence containing specific word
- Extract word within string in Excel row
- How do you extract the first sentence in Excel
- In Excel, how do I extract last four letters of a ten letter string?
- Extract second, third and fourth word of a cell in a googlesheet
- Can't get the first part of a text from a string using formula
- Excel function to get first word from sentence in other cell
- Extract a Word from String Containing a Specific Character within Substring
- How to capture only one word from a sentence in Excel?
- Extract words from delimited string in Excel?