INITCAP() (formerly PROPER()) converts a text to proper case: the first letter of each word in upper case and every other letter in lower case. Use it to tidy names, cities and titles that arrive all in capitals or all in lower case.
INITCAP(string) INITCAP() returns a character string
INITCAP('apples') = 'Apples'
INITCAP('apples and oranges') = 'Apples And Oranges'
INITCAP('JOHN DOE') = 'John Doe'
// A word starts after anything that is not a letter
INITCAP('mary-jane') = 'Mary-Jane'
INITCAP('o''brien') = 'O''Brien'
INITCAP('3rd street') = '3Rd Street'
// Capitals inside a word are lowered too
INITCAP('McDONALD') = 'Mcdonald'
INITCAP('') = ''
INITCAP(NULL) = NULL