Capitalization rules for name fields

[JoJo]

Has anyone else come up against this one?
Working with a data source from Access which is all uppercase & need to get
Names/Salutation looking more human. Using \*Caps deals with 99% perfectly.
But McWilliams becomes Mcwilliams and O'Neill O'neill which looks rather
odd.
Has anyone come up with a way to deal with exceptions to the 1st Cap, rest
lowcase rule, or know of any routinesout there which will?
Although it was pointed out that this could net names for which this is not
applicable, I would prefer to weed these out after since with the source data
I have they will be a much smaller number.

 

[JoJo]

Many thanks for advice - not worried about offending "ee cummins" on this
one! Also realise we cant do much about the van/von ones, but still think its
better than doing mailshot all in caps!
Seems bizarre that Excel has this function & not Word