Extract 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
2009 - 2016