Excel UPPER Function
The Excel UPPER function converts all letters of a given text to uppercase.
- Numbers, special characters and punctuations are not affected by UPPER function;
- Only the lowercase characters of given text are changed.
Convert all letters of a given text to uppercase in Excel
If you want to convert a list of text strings to uppercase, you can apply the UPPER function as follows.
Select a blank cell, copy the below formula into it and drag the Fill Handle to apply the formula to other cells.