How to divide the each digit of the phone numbers into different c

A

ayahua5ca

More specifically, does anyone know how to divide the each digit of a phone
number in one cell into 10 different cells that each digit. Please help me,
it will save me so much time...

Thanks in advance.
 
G

Gary''s Student

with a phone number in A1, enter in A2:
=MID($A$1,COLUMN()-1,1) and copy across
 
A

ayahua5ca

I get this error "Correct a #VALUE! error"

And is it possible to have these digit values in the columns next to the
phone number sell and not under the phone number cell?

Thanks
 
B

Bernie Deitrick

That formula is written such that it need to go into cell B1, not A2.

=MID($A1,COLUMN()-1,1)

would be preferable if you have many phone numbers in column A, and need to copy the formulas down.

HTH,
Bernie
MS Excel MVP
 
Top