Hi Raju

One way..

In B1
=LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123 456789"))-1)

In C1
=SUBSTITUTE(A1,B1,)

--
Jacob (MVP - Excel)


"raju" wrote:

dear sir

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

thanks advance.

raju