Microsoft Word/Ecel Help

[bant]

Help me Obi-Wan Kenobi, you're my only hope.

Hi everybody I'm trying to extract an RTF List from an Excel File using three of the columns. How do I do this?

Comments

[darththalia]

More details, please? My initial reaction would be, assuming you have column headers, to use filters--if you go to the Data tab and click the Filter button, it'll put drop-down buttons on the column headings. You can then use the filters to choose the rows you want to extract. Then, if you select only the visible rows (ask me how if you don't know how to do this; it's kind of confusing, and I need to do some research), you can copy them to a new spreadsheet.

If that won't work, please explain in gory detail what you're trying to do. There's an excellent chance I can help.

[onci_dium]

Hey Thalia

What we're doing here is that I need a text file in order to put a guest list into a .doc file

What we need is for the Excel file with the columns Surname, Firstname, Country to extract to a RTF list that looks like

Surname, Firstname (Country)

for me to copypasta to the .doc file

[darththalia]

OK, if Surname is col A, Firstname is col B, and Country is col C, how about the following formula in cell D2:
=A2 & ", " & B2 & " (" & C2 & ")"

Then copy that down for the length of the table, then copy column D into a Word doc. Then, probably, convert table to text, and save as RTF.

Does that make sense?

[bant]

I'll try it. Thanks.

[bant]

It worked. Thanks.

[darththalia]

It occurs to me, you could also do this as a mail-merge in Word, if you're comfortable with that.

[bant]

That's what I'd like to do but my list comes out one name to a page. How can I do it so that I get them as a whole list on one page?

[darththalia]

I think you have to set up the fields all over the first page, not just once, if that makes sense. Try starting with a template for labels, maybe? I've never been any good at all with mail merge.

[ETA: No, wait, that makes no sense at all. Ignore that. I'm stumped.]