lsu-i-like Wrote:
i want to enter the number in the first cell of output, so using your
terminology, x1=a1. this creates a circular reference using left so
that wont work. i might have to use your way. in any case, your reply
is a big help. any additional help is appreciated.

NOTE that I never meant *-X1 to be equal to A1-*. These are two
independent and different cells.

In my example, X1 is where you have your "xxx-xx-xxxx" entered and the
individual single numbers will appear in Cell A1 up to Cell I1.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=379487