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

[Guest]

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.

 

[Guest]

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

 

[Guest]

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

 

[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