How to capitalize first letter in Excel and Google Sheets. We will look at how to capitalize the first letter of every word (title case) and how to capitalize only the first letter of the first word (sentence case).
Capitalize every word
If you want title case where the first letter of every word is capitalized, and your text is in cell A1, use this formula:
=PROPER(A1)
Capitalize only the very first letter
If you want sentence case where only the first letter of the first word is capitalized, and your text is in cell A1, use this formula:
=CONCATENATE(UPPER(LEFT(A1,1)),LOWER(RIGHT(A1,LEN(A1)-1)))
This formula capitalizes only the very first letter and turns the rest into lowercase.
If you want to capitalize the very first letter without turning the rest into lowercase, use the following formula instead:
=CONCATENATE(UPPER(LEFT(A1,1)),RIGHT(A1,LEN(A1)-1))