"Ron Rosenfeld" wrote in message
...
On Sat, 27 Dec 2008 08:11:26 -0800, "Andrew"
wrote:
Paste into some cell.
Select that cell
Data /Text to columns
Delimited
Select "semicolon" as the delimiter
Finish

Edit/Replace
Replace what: ' (single quote)
With: leave blank
Replace All

If you want these in a column, select the cells.
Copy
Select a destination (single cell which will be in the topmost row of
the destination range)
Paste Special: Transpose
--ron


Thank you Ron. I am using Microsoft Excel 2007.
I cannot find Data/Text to columns
Delimited?
Also, when I paste, should I paste into entire row instead of one cell,
then, each email address will put into one cell by itself?