See David McRitchie's site.
http://www.mvps.org/dmcritchie/excel/proper.htm
Gord Dibben MS Excel MVP
On Wed, 6 Jan 2010 19:39:02 -0800, Paul Wilson
wrote:
Hi,
I need to write some script that allows me to evaluate a cell values first 2
characters for "MC". If found Uppercase the 3rd Character. This way I can use
it and adapt it for any naming anomoly.
eg "MCCARTHY" - "McCarthy"
My thoughts were to put each character of the value and evaluate the first
character then the second. When a match is found re-write the value out of
the array in the correct casing format.
Cheers