There are easy formulas to make the letters in your cell UPPER CASE (LIKE THIS), lower case (like this) and Proper Case (Like This) but what if you need Sentence case (Like this)?
=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

Data analyzed and visualized.
There are easy formulas to make the letters in your cell UPPER CASE (LIKE THIS), lower case (like this) and Proper Case (Like This) but what if you need Sentence case (Like this)?
=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
