View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default text modification

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"jtaiariol" wrote in message ...
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
--
john