To change small letters to capital letters in Excel, use the built-in function UPPER.
Steps to change small letters to capital letters in Excel:
- Insert a new column next to the column containing the text you want to convert.
- In the new column, enter the formula
=UPPER(A2)where A2 is the cell reference of the text you want to convert. - Press Enter to convert the text in A2 to uppercase.
- Fill the formula down the column by dragging the small square handle of the formula cell to cover the rows you want to convert.
- Optionally, copy the converted results, then paste as values over the original data to replace the text with uppercase values only.
- You can delete the helper column if no longer needed.
Additional tips:
- Excel also has the
LOWER()function to convert text to lowercase. - The
PROPER()function capitalizes the first letter of each word. - There is no direct "Change Case" button like in Word, so formulas are the best built-in method.
- Alternatively, you can use the shortcut Shift + F3 to toggle case in text, but it works on selected text rather than cells.
This method efficiently converts all lowercase letters in your data to
uppercase letters using the UPPER() function.
