I would like to enter a number with 9 digits in a format like this -
(123-45-6789) and have each digit be placed in an individual cell.
A1=1
B1=2
C1=3, etc.

Is there a way to do this?


--
lsu-i-like
------------------------------------------------------------------------
lsu-i-like's Profile: http://www.excelforum.com/member.php...o&userid=14317
View this thread: http://www.excelforum.com/showthread...hreadid=379487