Proper with exceptions list

[HorsePop]

At my office deal with a lot of strings in BLOCK CAPS and we often use Proper to convert it to title case but there's a fairly regular list of abbreviations we run into where we don't want that specific word proper-ing (e.g. GTI, RS4 etc.).

Is there a good work-around / VB widget / way to do it with formulas?

I'm thinking I could either write some VB to evaluate each word in turn against a list or use search and then substitute to substitute the word from a string (although presumably this is only gonna work if there's just one of the words on my list - perhaps I could run the same process two or three times) but just wondering if there's any existing solution for this because it seems like a really obvious thing to want to do.

Did try search, to no avail.

Cheers.

[ragulduy]

Well if you have your text in A1 and your abbreviation in A2 (in caps) then:
=SUBSTITUTE(PROPER(A1),PROPER(A2),A2)
would give you the correct term with your exception in A2.

You could maybe use this idea with a macro, such as:

Please Login or Register  to view this content.

and use
=proper_with_exceptions(a1,a2:a10) to make A1 proper but excepting the values in a2 to a10.

[HorsePop]

Comparing that to the method I was trying I just feel fick. Many thanks