HELP! Database w/o database tools - email substitution

[asterroc]

I have an MS Word file w/ a table in it. One column is people's names, another is their email addresses. I need to put either the email addresses or names in to web access for Outlook with semicolon separations. If I copy and paste either column unformatted, I get carriage returns at the end of each entry, rather than semicolons. Is there an easy way to change the returns into semicolons in MS Word? It doesn't seem to be possible to do a find an replace on a return. There's 600 entries so while it's *possible* to do by hand, it's *not* a good choice.

Comments

[l0stmyrel1g10n.livejournal.com]

if you display hidden characters, you can copy and paste the newline character into the find/replace box.

[the-xtina.livejournal.com]

*checks*

- Copy the column and paste in Word at the end of the doc as unformatted text.
- Highlight that text and hit Ctrl-H to open Find/Replace.
- In the Find box, put ^p.
- In Replace, put ;.
- Then just be careful with not having the F&R do that for the whole document.

(I'm using Word 2007, but it's also there in 2003 at least, possibly also 2000.  Also, search direction is down, hence posting at the end of the doc - it'll F&R to the end, then ask if you want to continue from the top - hit No.)

[gemini6ice.livejournal.com]

find/replace \n which is a carriage return

[kelsin.livejournal.com]

Use emacs and turn your life around!

I'm sorry, I had to be that guy :-(