Hi Prashant,

Try,

In B1,

=LEFT(A1,LOOKUP(9.999E+307,FIND(" ",A1,ROW($A1:$A35))))

In C1,

=TRIM(LEFT(SUBSTITUTE(A1,B1,""),LOOKUP(9.999E+307, FIND("
",TRIM(SUBSTITUTE(A1,B1,""))&" ",ROW($A1:A25)))))

In D1,

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

HTH


--
Krishnakumar


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