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

Splitting Text?
 

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

Splitting Text?
 

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

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

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