How to Capitalize First Letter in Google Sheets Automatically using PROPER formula is shown in this video. The PROPER function capitalizes the first letter of each word in a text string. If you want to capitalize only the first letter, in cell type =PROPER(Click on cell containing text) and press enter on the keyboard. You can now draw the formula to capitalize first letter on other cells. The method also works on Excel
#googlesheets