Merge field with surname with upper and lower case letters e.g. M.

[Sue]

Hi
I have to create a merge field that detects surnames that have the first
letter in u/c and third letter in u/c e.g. McDonald. Same for surnames like
MacDonald or de Moray. I should be using the IF Statement but I don't know
the formula/merge field command to setup?

Can you help?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?U3Vl?=,

I have to create a merge field that detects surnames that have the first
letter in u/c and third letter in u/c e.g. McDonald. Same for surnames like
MacDonald or de Moray. I should be using the IF Statement but I don't know
the formula/merge field command to setup?

Word doesn't really have any tools for working with string (textual)
information in this manner. Usually, for something like this you need to
process the data while it's still in the data source.

What's your data source type?
Which version of Word are we dealing with?
What's the purpose of detecting these kinds of names?
And what do you want to do with them?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail