Google Sheets Tips - Formatting Sentences With Functions

The PROPER function is made to capitalize the first letter of each word. In this video we'll see how we can use a few other functions to capitalize only the first letter of sentences.

Here is the resulting function:
=UPPER(LEFT(B6,1))&LOWER(RIGHT(B6,LEN(B6)-1))

Check out the full Understanding Functions course on Udemy:
https://www.udemy.com/google-sheets-understanding-functions/

Видео Google Sheets Tips - Formatting Sentences With Functions канала Digital Egghead