Description
ProperCase capitalizes the first letter of each word in the string and converts all other letters to lower case.
Action
ProperCase capitalizes the first letter of each word in the string and converts all other letters to lower case. It also capitalizes any letter that follows a non-alpha character.
This function is particularly useful for capitalizing people's names correctly when they are stored as all capitals in a database.
Examples
ProperCase ("LINDA FONG")
This example will return "Linda Fong".
ProperCase ("123Michael's")
This example will return "123Michael'S".
Comments
This function is similar to the "Proper" function in Excel.