|  

» 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))


Rate This Tip
12 34 5
Rating: 3.67     Views: 26300
No comments have been submitted.
Name
Comment Title
Comments