Spreadsheet column into text list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top