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

[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.)

[zandperl.livejournal.com]

And it works in Word for Mac too. ;) Thanks!

[best-ken-ever.livejournal.com]

This was the suggestion I was going to make! Good job, the_xtina! MS products work when one knows how to do stuff in them. Sadly, such exercises are rarely intuitive...(I want an iWindows Touch...)

[zandperl.livejournal.com]

You want a what?

Oh right, I forget you database thingits too (though for different reasons than the_xtina). Silly me.

[best-ken-ever.livejournal.com]

I sadly don't seem to be able to use my MS Office skills as much at this job as I did at the previous one. Maybe I should just study up and become an Excel guru, get MS-certified and consult for a living...