Spreadsheet column into text list

L

lib900168

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

Trevor Shuttleworth

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
 
Top