How do I make capital letters in Excel?

Answer 1

You have a couple of ways of making letters upper case.

If you want all of your letters converted to upper case:

From a cell in your spreadsheet, type =UPPER, then select the cell that contains the text value that you want to convert to uppercase. Press enter, and your upper case value should show in the cell you type the Upper Formula into.

If you just want the first letter of your word to be set to upper case, the formula you want to use is formula: =PROPER(A2) where cell A2 contains the text you want the first letter capitalized.