Surely you can figure it out now that you see how search/find works with
left/mid/right

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken" wrote in message
...
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