Splitting Text?

[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

 

[Don Guillett]

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

 

[Ken]

Ok ... I got it ...

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

Thanks ... Kha

 

[Don Guillett]

Looking in the help index for LEN may also be useful.

 

[Don Guillett]

Glad you got it. See how much better if feels to catch the fish yourself.