A note of appreciation for David McRitchie's Excel website

[josh]

I finally got a few hours free to begin to look at David McRitchie's web
site mvps.org/dmcritchie/excel/excel.htm
and I must say I was just overwhelmed with how much really useful
information it contained.
Recently I posted and inquiry on Celtic names forum
http://members3.boardhost.com/cgisnames/index.html?1073625022 asking about
software which would correct the capitalization of certain Celtic names (not
much help there). So started writing my own Excel macro. I needn't have
started because there was the exact solution on David's web site. Wow!

Josh Page

 

[David McRitchie]

Hi Josh,
Glad you found it, that was a rather round about way of finding
it for a person in the Excel newsgroups.

There are lots of variations, for which you have to code
your own exceptions and possibly change the results manually
if you have a big list where people capitalize the same name
or same spelling differently. Mackintosh is an example there are
different spellings and different capitalizations. In fact I specifically
avoid automatic changes to anything beginning with "Mack" so
you would have to code your own exceptions. Or as Daire posted
under Margaret's posting (in your reference)..
the capitalization varies from family to family. While one could be
MacArthur, another will be just Macarthur, McNeil/Mcneil, etc.

Material also available for some mainframers as REXX macros in
Proper and LCFIX at http://www.mvps.org/dmcritchie/rexx/nclist.htm