Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | November 12, 2024
Extract the First Word from a Text String
The following formula extracts the first word from the text string in B3...
=TEXTBEFORE(B3," ")
For earlier versions of Excel...
=LEFT(B3,FIND(" ",B3)-1)
Based on the sample data, the formula returns "Caress".
Sample Workbook: Download