Thread
:
Splitting Text?
View Single Post
#
1
Posted to microsoft.public.excel.misc
Ken
external usenet poster
Posts: 590
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
Reply With Quote
Ken
View Public Profile
Find all posts by Ken