| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Numbers in a cell
I have a worksheet that has multiple numbers (1234, 3425, 34234,etc.) in a
single cell. I need to separate these and create a new row for each one (ie. A1 1234, A2 3425, A3 34234, etc.). Currently I'm having to insert columns, convert text to columns, transpose the data, then copy and paste the rest of the data from the other columns...Is there an easier way? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to separate multiple numbers in one cell | Excel Worksheet Functions | |||
| add multiple numbers in one cell with those numbers remaining visi | Excel Worksheet Functions | |||
| Selecting specific numbers from a cell containing multiple numbers | Excel Worksheet Functions | |||
| can a single cell contain multiple numbers? | Excel Worksheet Functions | |||
| Can you add multiple numbers in the same cell%3f | Excel Worksheet Functions | |||
Threaded Mode
