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