When you show just one example lots of questions are unanswered.
Do you always have 9 digits before the text?
Is the ABA part of the entry or is 123456789SMITH in a cell on its own?
Have you experimented with Data | Text to Columns ?
come back and we will try to help
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"gmoexcel" wrote in
message ...

Here are my sample cells:


A B C D
ABA 123456789SMITH
ABA
ABA
ABA
ABA

I want to go from the example at the top to the example
at the bottom. Is there a function or formula that will allow
me to separate numbers from text?

A B C D
ABA 123456789 SMITH
ABA
ABA
ABA
ABA


--
gmoexcel
------------------------------------------------------------------------
gmoexcel's Profile:
http://www.excelforum.com/member.php...o&userid=23324
View this thread: http://www.excelforum.com/showthread...hreadid=513675