Tip Printed from ExcelTip.com

---

Extracting the First N Number of Words from a String


Problem:

Extracting the first three words from each of the strings in column A.

Solution:
Use the TRIM, LEFT, FIND, and SUBSTITUTE functions as shown in the following formula:
=TRIM(LEFT(A2,FIND("^",SUBSTITUTE(TRIM(A2)&" "," ","^",3))-1))