| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperate digits of a number by columns and back again
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 -- Have a GREAT day! Mar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seperate digits of a number in a cell by columns and back | Excel Discussion (Misc queries) | |||
| How do I seperate a 10 digit number into one cell for each number? | Excel Discussion (Misc queries) | |||
| How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| worksheet columns changed from letter to number, how change back | New Users to Excel | |||
Threaded Mode
