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.

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

A couple more things to do (and a correction):

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

Remove the space characters via Edit|replace
select the text to fix (in MSWord)
ctrl-h
type a space character 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|Text (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

On Sat, 27 Dec 2008 08:11:26 -0800, "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.

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

"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?

On Sat, 27 Dec 2008 17:35:36 -0800, "Andrew" wrote:

"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?

If you have the default set up,
Data is one of the options on the same line as the Home tab.
If you then look at the section of the ribbon entitled "Data Tools",
Text to columns is the first entry.

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?

If you already have a method to put each email address into one cell by itself,
I don't understand why you are asking the same question here.???
--ron

"Ron Rosenfeld" wrote in message
...
On Sat, 27 Dec 2008 17:35:36 -0800, "Andrew"
wrote:

If you have the default set up,
Data is one of the options on the same line as the Home tab.
If you then look at the section of the ribbon entitled "Data Tools",
Text to columns is the first entry.

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?

If you already have a method to put each email address into one cell by
itself,
I don't understand why you are asking the same question here.???
--ron

Ron, thanks for your reply.
I click "Text to Columns", and the dialog panel "no data was selected to
parse" appears.

I am unable to paste this entire string of email address, each address into
one cell.
I do able to paste the entire string into one cell.

On Sun, 28 Dec 2008 18:34:06 -0800, "Andrew" wrote:

"Ron Rosenfeld" wrote in message
.. .
On Sat, 27 Dec 2008 17:35:36 -0800, "Andrew"
wrote:

If you have the default set up,
Data is one of the options on the same line as the Home tab.
If you then look at the section of the ribbon entitled "Data Tools",
Text to columns is the first entry.

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?

If you already have a method to put each email address into one cell by
itself,
I don't understand why you are asking the same question here.???
--ron

Ron, thanks for your reply.
I click "Text to Columns", and the dialog panel "no data was selected to
parse" appears.

I am unable to paste this entire string of email address, each address into
one cell.
I do able to paste the entire string into one cell.



Then the active cell (the cell which you selected before selecting "Text to
Columns" is empty.
--ron