| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - A string of #s needs to be separated into individual
I have a string of number in one cell separated by semicolons. How does I
get Excel to place each number in an individual cells? Is there a way to use the "Find and Replace" option to do this. the string looks like: 1;2;3;4;5;6;7 i'd like 1 to be in a cell 2 to be in a different cell and so on. Also, I would like them to move downward in the cells (A1, A2, A3, A4, A5, etc). Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to number lists separated by a space on Excel? | Excel Discussion (Misc queries) | |||
| Seperate cell string into individual cells | Excel Worksheet Functions | |||
| Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
| Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
| Coverting string of text into individual sums? | Excel Discussion (Misc queries) | |||
Threaded Mode
