| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I split one cell of 6 numbers into two cells of 3 and 3?
I have a column of data that has six numbers in each cell, however I need to
split this into two columns, where the first column is the first three digits and the second column is the last three. There is no separator (space, comma or dash) between the numbers. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
| How do I format a cell so that only specific numbers can be enter. | Excel Discussion (Misc queries) | |||
| Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| combining several individual cells of numbers into one cell | Excel Worksheet Functions | |||
Threaded Mode
