MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Extract 1st Word in a Phrase


Posted by Michael on August 28, 2001 11:39 AM

If cell A1 = Acme Widget Company
How do I get A2 = Acme?


Posted by Mark W. on August 28, 2001 11:40 AM

=LEFT(A1,FIND(" ",A1)-1)

Posted by Michael on August 28, 2001 11:44 AM

Mark W:

Thanks. How would the formula be different if we extracted the first 2 words of 3?