Breaking apart a number in a cell into seperate cells

  • Thread starter Thread starter Ron Lichtman
  • Start date Start date
R

Ron Lichtman

I have a schedule with 10 digit numbers in each cell
(about 2,000 rows).
I need to apply a different formula to each digit in the
cell.
Is there a way to get the number in a single cell into 10
seperate cells so I can aplly the formulas to each cell
(The same formula is always used for the first digit in
the cell, a second formula to the next digit etc.

If you can e-mail the reponse as well as post I would be
most appreciative. Not sure I can find this post again.

Also - I would love a tip on how to search post topicsse
posts so if this question was previously answered I would
be able to search before redundantly posing the same
question.
 
If your numbers start in A4 in let's say B4 put this formula

=MID($A4,COLUMN(A:A),1)

copy across 10 columns, then copy down 20000 rows by double clicking in the
lower right corner of the
right most filled cell (in my example K4), while still selected copy the
range and in place do edit>paste special as values

Now you'll have text numbers, you could either amend the formula with

=--MID($A4,COLUMN(A:A),1)

or copy an empty cell, select the new range and do edit>paste special and
check add..
 
Back
Top