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.

[zandperl.livejournal.com]

I'd already tried it and it didn't work, returns can't be pasted into a find/replace box. the_xtina's suggestion below does though.

[l0stmyrel1g10n.livejournal.com]

really? it always works for me.

[the-xtina.livejournal.com]

It doesn't work for me, either.  What version are you using?  *all curious now*

[l0stmyrel1g10n.livejournal.com]

i've actually never tried it on a Mac, but over the summer i was using some Windows machine, and i have no idea what version that was. i don't even know what version of Windows it was. didn't bother to check, only using it briefly.

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

[gemini6ice.livejournal.com]

find/replace \n which is a carriage return

[zandperl.livejournal.com]

Well, the ^p suggested above worked. I'll give \n a shot next time to see if there's a difference.

[kelsin.livejournal.com]

Use emacs and turn your life around!

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