Help with Microsoft Word listing

Factual Questions
1

So I need to send an email to the faculty at my school, and after much effort, I extracted the email addresses into a separate document. They are now in a line-break separated list. I need them to be in a comma separated list. I’ve tried importing into excel, and saving as a comma-separated list, but when I take it back into Word, it line-breaks them. Rather than hit comma, delete, end ad nauseaum, how can I automate this process?

2

Here’s what I came up with:

  1. Take your Word data (one item per line) and paste it into Excel. It should put one item per row in Excel.
  2. Highlight all of your Excel data.
  3. Right-click and choose “Copy”
  4. Go to Sheet 2 in Excel.
  5. Right click and choose “Paste Special”
  6. Check the “Transpose” box in the “Paste Special” window. This will paste everything into your new spreadsheet as one item per column instead of one per row.
  7. Highlight all of your data on Sheet 2.
  8. Right-click and choose “Copy”
  9. Open Notepad (Start - Run - Notepad.exe)
  10. CTRL-v to paste your data into Notepad
  11. Use your cursor to highlight the space between Email1 and Email2. Hit CTRL-c to copy that space.
  12. Hit CTRL-h to bring up the “Replace” function in Notepad.
  13. Put your cursor in the “Find What” box and then hit CTRL-v to paste the “space” into that box.
  14. In the “Replace With” box, type a comma. Then hit “Replace All”

That should give you a comma-delimited list of email addresses.

3

ctrl-a
ctrl-h
^p
tab
,
alt-a

Seriously: ctrl-a selects all text. ctrl-h brings up the “Find and Replace” dialog. You enter ^p in the “Find What” and a comma in the “Replace With” boxes. Alt-a replaces all occurences.

^p is the code that represents paragraph breaks.