I would do this.

Paste into MSWord.

Remove the apostrophes via Edit|replace
select the text to fix (in MSWord)
ctrl-h
type an apostrophe in the "Find what:" box
make sure the "replace with:" box is empty
then click replace all button

Change the semicolons to carriage returns/linefeeds.
select the text to fix (in MSWord)
ctrl-h
type a semicolon in the "Find what:" box
click in the "replace with:"
hit the more button
hit the special button and choose Paragraph mark
then click replace all button

Select the text
edit|copy
Select the top cell in excel
edit|paste special|values (to avoid bringing the format with the text)




Andrew wrote:

How to copy / paste email addresses into each cell in the spread sheet?

We are using Outlook for email. For intra-office memo, we have long list of
email addresses in different project groups and different discussion /
meeting groups of distribution list.
Typical Outlook email address in the cc: list string we can copy / paste
from is like this
'; '; '; ';

How can I copy the entire string and paste these email addresses into
each individual cell in the spread sheet? I would like each email address
pasted in one cell of its own. Can you please tell me how to do it?

Thank you.

--

Dave Peterson