To convert small letters (lowercase) to capital letters (uppercase) in Excel, you can use the built-in UPPER function. Here's how to do it step-by-step:

Using the UPPER Function

1. Insert a helper column next to the column containing the text you want to convert.

2. In the first cell of the helper column (e.g., B2), enter the formula:

   =UPPER(A2)
   

Replace A2 with the reference to the cell containing the lowercase text.

3. Press Enter. This will convert the text in A2 to uppercase in B2.
4. Copy the formula down the helper column to convert all corresponding cells.
5. If you want to replace the original text with the uppercase text, copy the helper column, then right-click the original column and choose Paste Special > Values to paste only the uppercase text.
6. You can then delete the helper column if you no longer need it.

This method converts all letters in the text to uppercase

Additional Tips

• You can also use the keyboard shortcut Shift + F3 in Word to toggle case, but Excel does not have this feature natively. However, you can create a VBA macro to toggle case and assign it to Shift + F3 for convenience

• If you want to convert text in place without a helper column, you can use VBA code to convert selected cells to uppercase

This approach is straightforward and works well for converting any text from lowercase to uppercase in Excel.