Ok ... I got it ... :)

=RIGHT(E12,LEN(E12)-SEARCH(" ",E12))

Thanks ... Kha

"Ken" wrote:

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