Extract the First Word from a Text String

Extracting the First Word from a Text String

The following formula extracts the first word from the text string in A2...

=LEFT(TRIM(A2),FIND(" ",TRIM(A2)&" ")-1)

Based on the sample data, the formula returns "sample".

Sample Workbook: Download