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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sue - 19 Aug 2004 06:43 GMT

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?

Reply to this Message

Cindy M -WordMVP- - 21 Aug 2004 12:11 GMT

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 :-)

Reply to this Message

Rate this thread: