View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mar Nighbor Mar Nighbor is offline
external usenet poster
 
Posts: 1
Default Seperate digits of a number in a cell by columns and back

I am working with numbers of multiple digits in a single cell. I would like
each digit to be in its own cell within the same row, in multiple columns.
Then I am going to perform calculations on the numbers. Afterwards, I would
like to consiladate the numbers back into the same cell again.

Any ideas without using macros. I am unable to record macros on my
computer, unless you know a way around doing this without actually recording
a macro.