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