Is there a formula or shortcut to change text to Proper case?

I have a very large sheet where some of the text was written in upper case. I know the UPPER and LOWER functions will change the entire sentence to lowercase, but is there a PROPER function (like in excel) to capitalize the first letter of the sentence with the subsequent letters in lower case?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!