xl-central.com, Your Quick Reference to Excel Solutions





navleft
navright
spacer
Extract the First Word from a Text String

Extract First Word from a Text String

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

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

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

spacer
Wu Yi Tea
Website Designed by Wu Yi Tea
Design downloaded from free website templates.
Wordpress Themes