| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Seperating Data within cells
I have a huge data file with colums contain data that need to be seperated
The data was entered into the cells 2#5#8# etc. (numbers can range from one to 38). I need to get all the 2's into a colum all the . 3's, 4's, 5's... and they all need to line up. I am trying to figure out how to do this since one cell may start with one number and then next cell a different one? Please help! I hope this makes sense. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort data in cells in a row | Excel Worksheet Functions | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
| How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
| Averaging only cells with data | Excel Discussion (Misc queries) | |||
| cells lose relativity to other WorkSheets after data sort? | Excel Worksheet Functions | |||
Threaded Mode
