| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Assuming the data to be in column A
in B1=LEFT(A1,3) in C1=RIGHT(A1,3) If you want the results as numeric, then put *1 at the end of each formula. Copy down the range required -- Regards Roger Govier "Jason" wrote in message ... 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
