how to make small letter to capital letter in excel

To change small letters to capital letters in Excel, you can use the built-in UPPER function. Here's how to do it:

1. Suppose your text is in cell A2.
2. In a new cell, type the formula =UPPER(A2) and press Enter.
3. This formula converts all the text in cell A2 to uppercase letters.
4. Drag the fill handle down to apply this to other cells if needed.
5. If you want to keep only the capitalized values and remove the formula, copy the new column, then paste as values back into the original cells.

This method is simple and effective to convert lowercase or mixed-case text to all capital letters in Excel.