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.