View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default All email addresses in one cell, how to seperate them?

If they are separated by a common character such as a comma or a semi-colon,
you can use Text to Columns. Hopefully you don't have more addresses than
columns your version of Excel will support.

Regards,
Fred.

"Mukesh" wrote in message
...
I have many email addresses in one cell, how do I seperate them to
individual cells? Please help.

Thanks.
Mukesh