Hi,

Another option..

In B1,

=LOOKUP(9.999999999E+307,--MID(A1,1,ROW($1:$1024)))

In C1,

=TRIM(SUBSTITUTE(A1,B1,""))

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=494996