This Microsoft Excel video shows how to capitalize only the first letter of a sentence with a formula.
Combining the functions: Upper, Lower, Left, Right, and Len, a formula can be curated to automatically change any string of text to be only have an uppercase first letter.