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