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