Thread
:
Splitting Text?
View Single Post
#
5
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Splitting Text?
Glad you got it. See how much better if feels to catch the fish yourself.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Ken" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett