K
Ken
Excel2003 ... A Col with TEXT
This formula returns Text to the LEFT of the 1st space found in the text.
=LEFT(E2,SEARCH(" ",E2)-1)
Now ... What formula will return ALL Text to the RIGHT of the 1st space?
Thanks ... Kha
This formula returns Text to the LEFT of the 1st space found in the text.
=LEFT(E2,SEARCH(" ",E2)-1)
Now ... What formula will return ALL Text to the RIGHT of the 1st space?
Thanks ... Kha