Yes there is always 9 digits on the left of the text, that's why I went
from 1 to 9 as in a SSN. Never mind the ABA, has nothing to do with
the question. 123456789SMITH is a cell on its own, that is the one I
am attempting to separate.

What is Data | Text to Columns ?

This is starting to get very complicated.

gmo

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


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