View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default Once I paste email addresses seperated only by comas into Excel h.

make sure the file ends in .txt, in excel do a file/open for Files of Type
pick text files, select the file, then pick delimited, next, pick coma, etc

"Red Scoop" wrote:

Once I paste a large list of email addresses seperated only by comas into
Excel how do I make them each go into their own cell? The entire list is
currently ALL in one cell but I need each of the thousand email addresses to
be in it's own individual cell.

Thanks!