Extract 1st 2 words in a Phrase
Posted by Michael on August 28, 2001 11:48 AM
Similar to question before, if:
A1 = Acme Holding Company
How do I get A2 = Acme Holding?
Posted by Mark W. on August 28, 2001 11:52 AM
=LEFT(A1,FIND(" ",A1,FIND(" ",A1)+1))
Posted by Mark W. on August 28, 2001 11:54 AM
Make that...
=LEFT(A7,FIND(" ",A7,FIND(" ",A7)+1)-1)
