I'm trying to clean up my customer database and prevent new entries to be all caps or weird random capitalization (sometimes employees can do that when adding data). The built in proper() function works fine for the most part, except that when the string has a period in it, I want to make the next character to be capitalized.

For example: JOSE VILCHES is converted correctly to Jose Vilches. But a company name like BRONDBY S.A. would be converted to Brondby S.a. instead of Brondby S.A.

I would like to make it so that anything that follows a period is capitalized and take into account that there could be more than one or two periods. I figured I could do this by counting ocurrences of "." then do a loop on the string, except I can't find the way to do that.