lsu-i-like Wrote:
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?
Assuming your entry is in Cell X1, this are your formulas:
A1: =left(X1,1)
B1: =mid(X1,2,1)
C1: =mid(X1,3,1)
D1: =mid(X1,5,1)
E1: =mid(X1,6,1)
F1: =mid(X1,8,1)
G1: =mid(X1,9,1)
H1: =mid(X1,10,1)
I1: =right(X1,1)
Hope this is what you are looking for.
Regards.
--
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread:
http://www.excelforum.com/showthread...hreadid=379487