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