Spreadsheet column into text list
 

I am working with an Excel spreadsheet of addresses and other information. I
have email addresses in the last column, but I need to find a way to get them
into a text list. I could copy the list into a text editor and delete all of
the new line marks, but that would be very time consuming. Is there a better
way to make a column into a list?

Spreadsheet column into text list
 

I'd select the column, copy it, paste special (unformatted text) into word.
Then do a global replace of the paragraph marks (^p) with space or comma or
comma and space

Find what: ^p
Replace with: ,

Regards

Trevor


"lib900168" wrote in message
...
I am working with an Excel spreadsheet of addresses and other information.
I
have email addresses in the last column, but I need to find a way to get
them
into a text list. I could copy the list into a text editor and delete all
of
the new line marks, but that would be very time consuming. Is there a
better
way to make a column into a list?