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?
