Change Case in Merge

C

Carl Martin

I get a new Excel workbook every week that contains names and addresses in
all upper case. How can I set the case to Proper when merging into Word
2008?

Do I have to write the formulas in Excel to convert to Proper case first,
then do the merge, or is it possible to force the case during the merge?

Thanks,

c~

Carl Martin
San Angelo, TX
 
P

Peter Jamieson

If you use Alt-F9 to view your fields and see e.g.

{ MERGEFIELD myfield }

then strip out any \*Mergeformat in the field and insert \*Caps to give you

{ MERGEFIELD myfield \*Caps }


Peter Jamieson

http://tips.pjmsn.me.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top