Thread
:
Splitting Text?
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Splitting Text?
Looking in the help index for LEN may also be useful.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Don Guillett" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett