Try: http://www.ozgrid.com/VBA/ExtractNum.htm to pull the number into C1,
then: =SUBSTITUTE(A1,C1,"") in B1



--
Regards
Dave Hawley
www.ozgrid.com
"raju" wrote in message
...
dear sir

in Cell A1 is "rajulu1234". i want in cell B1 "rajulu" & cell C1 "1234".
please help me.

thanks advance.

raju