how to paste email address string into each cell in the spread sheet

[Andrew]

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
'(e-mail address removed)'; '(e-mail address removed)'; '(e-mail address removed)'; '(e-mail address removed)';

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]

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)

 

[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)

 

[Ron Rosenfeld]

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
'(e-mail address removed)'; '(e-mail address removed)'; '(e-mail address removed)'; '(e-mail address removed)';

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

 

[Andrew]

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?

 

[Ron Rosenfeld]

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

 

[Andrew]

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.


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.

 

[Ron Rosenfeld]

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