Word Merge Field Switches

[bkclaw113]

I have a dataset that has a list of names and address. The data is in all capital letters. Now when performing the mail merge I use the Propper Case switch ( \*Caps ). This works for most of my records but not all. For instance:

JOHN MCDONALD --> John Mcdonald
JOHN SMITH III --> John Smith Iii
DE NATION BANK, NA --> De Nation Bank, Na

How can I get this type of information formated correctly?

John McDonald
John Smith III
DE Nation Bank, NA

Additional information: Currently datasource is in Excell, but can easily moved to different format (Access, text file, ...)

 

[Dreamboat]

You're better off converting it in Excel, and using the converted column.

=Proper(cellref)

When you're done, there's really no choice but to select the letter of the column and do some finds/replaces. Such as Iii with III.

Depending on the number of records, I usually sort that list and just glance through it for things that stick out at me. Hate to say, there's no easy way. Anne Troy
Dreamboat@TheWordExpert.com
Anne@MrExcel.com

 

[Dreamboat]

Oh...PS. When you search things like Na, make sure you search for:

<space>Na<space> so it doesn't replace every Na in the file, like NAncy.

Something like <space>Mcd can be replaced with <space>McD...just be careful and give it some thought. Anne Troy
Dreamboat@TheWordExpert.com
Anne@MrExcel.com

 

[bkclaw113]

Thanks for the response, I think that I will use part of your suggestion and create a lookup table and write a find and replace Macro that uses the table. This way each time that I identify a new abbreviation or letter combination I can put it into the lookup table and after running this a few times should have a fairly comprehensive solution.