text modification

[Guest]

i have a series of 5 numbers separated by commas listed in one cell. i would
like to extract each number and list them in separate cells. what is the best
way to achieve this? thanks

 

[David McRitchie]

The easiest way would be to make sure you have the appropriate
number of empty columns to the right then use Data, Text to Columns
You have *delimited* text, and on the next dialog you would indicate
comma as your delimiter.