View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How do I de-concatenate items separated by commas!

Hi,

data|Text to Columns

Follow the wizard and use a comma delimeter

Mike

"Taneli Hanhivaara" wrote:

How would I take a list of items separated by commas in a field and make each
item its own field (column or row)?