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

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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.
 
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)
 
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)
 
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.
Click to expand...

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 said:
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
Click to expand...


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?
 
Thank you Ron. I am using Microsoft Excel 2007.
I cannot find Data/Text to columns Delimited?
Click to expand...

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?
Click to expand...

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
 
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
Click to expand...

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, 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.
Click to expand...

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