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

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.

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

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


"ayahua5ca" wrote:

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.

How to divide the each digit of the phone numbers into differe
 

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

"Gary''s Student" wrote:

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


"ayahua5ca" wrote:

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.

How to divide the each digit of the phone numbers into differe
 

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


"ayahua5ca" wrote in message
...
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

"Gary''s Student" wrote:

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


"ayahua5ca" wrote:

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.