Thread: Splitting Text?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Splitting Text?

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