Ron Rosenfeld showed you solutions using REGEX and Longre's free
morefunc.xll add-in

muddan madhu showed you the array formulae
=MID(A1,MATCH(TRUE,ISNUMBER(1*MID(A1,ROW($1:$20),1 )),0),COUNT(1*MID(A1,ROW($1:$20),1)))
and
=MID(A1,ROW($1:$20),LEN(A1)-COUNT(1*MID(A1,ROW($1:$20),1)))

It's no good coming back and repeatedly asking the same question if you
don't explain what was wrong with the previous answers you've had.
--
David Biddulph

"Tazeem" wrote in message
...
Dear Mr. David,
I have tried but the results based on some specific condition of delimited
with any character such as commas, tabs or fixed numbers etc. Whereas,
there
is no fixed no. of digits in the data I have. Need help.

Regards,

"David Biddulph" wrote:

Try one of the answers you were given the last time you asked the
question.
--
David Biddulph

"Tazeem" wrote in message
...
Is there any shortcut to separate (text and number - like ABCDE123456)
of
a
single cell?. Especially if the no. of digits are not constant. Thanks