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
|