exceptions in case sensitivity
I have a field where I have a lot of titles which I want the Initial Letter Capitalized, but do not want the to's, the the's, and many small letters capitalized, but I have a few letters that I want capitalized that are in a row, such as III. Is there a way to list get the initial letter capitalized in the big words, the small words not capitalized and then the extra like the III to be all upper case.
Thanks for any help on this.
I suppose you could write a script or recursive custom function that would loop through your text field one word at a time, I'm assuming that you have a large text field with multiple lines of text here, and uses, Upper, and Proper to selectively capitalize the individual words, but it would be a challenge to set up in such a way that every possible exception is correctly "cased".