Select the cell E3 and write the formula: =PROPER(B3).Capitalize first letter in Excel for each word For each word in the cell, this function converts the first letter to the upper case.įigure 3.

To capitalize each word in Excel we can use the PROPER function. How to capitalize all letters in Google Sheets Capitalize First Letter in Excel with the PROPER Function Copy the formula down by dragging icon “+” of the cell, as explained in the example above.įigure 2. Select the cell D3 and insert the formula: =UPPER(B3). Logic is the same if we want to capitalize all letters in Google Sheets.

Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.

Select the cell D3 and write the formula: =UPPER(B3).

Formula syntax is simple, we just have to select the cell where we want to capitalize the letters.įigure 1. This function converts all characters in the text to the upper case.

If we want to have all caps letters in excel cell, we should use the UPPER function. Capitalize all letters in Excel with UPPER Function Word is the fastest solution to get sentence case in Excel or Google Sheets without using formulas. If we want to capitalize the first letter of each word in the cell we can use the PROPER function. To capitalize all letters in Excel or Google Sheets we can use the UPPER function or Word as a faster solution. How to Capitalize Letters in Google Sheets and Excel

Make all text uppercase excel