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.