View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Burger23
 
Posts: n/a
Default Import Comma delimited info in a Column

I apolgize if this is the wrong Forum for this question- if so, please
redirect me. Thanks

I have hundreds of email addresses listed in a Wordpad file- entries are
separated by a comma. When I use the Excel Import function, all data is
successfully imported into an Excel spreadsheet- BUT in a single row. I would
like to have this info in a single column (A)- then I could easily
alphabetize the entries and eliminate duplicates.

Thanks for any help...