I need help creating a Capitalization Regular Expression

How would the Regex/Macro determine to, e.g. ALLCAPS "diy" but Title Case "use"? Would you have a finite list of special abbreviations and such, and how to deal with them?

Have a look at placing your Search and Replace within a For Each.


A thread going into detail about this approach: