Maybe MID would fit the bill ?

Perhaps an example to illustrate

Assuming A1 contains: text1 text2
with similar in A2 down
and we want to split col A into cols B and C

In B1: =LEFT(A1,SEARCH(" ",A1)-1)
In C1: =MID(A1,SEARCH(" ",A1)+1,99)

B1 returns: text1
C1 returns: text2
(the "99" in MID is arbitrary, adjust the number to suit)

To split it similarly for A2, A3, A4 ....,
just select B1:C1 and copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Munawar Amin" wrote:
Pls tell me the solution.

I want to get remaining text after using LEFT function