UPPER function in Excel helps you turn lowercase to uppercase in Excel. Thanks to this function, you save a lot of time and effort when working on spreadsheets.
How to use UPPER function in Excel?
Instructions on how to use the UPPER function in Excel – Example illustrations
Syntax: UPPER (text)
Inside: Text: The text you want to convert to uppercase.
Consider Example: You have a column of first and last names lowercase
Now you want your full name to be in uppercase, you do as shown below. Enter the formula in the cell E5, we get results
Drag and drop to get the results for the remaining cells
So you already know how to use the UPPER function to convert lowercase to uppercase in excel already. Alternatively, if you want to convert the first character in the string to uppercase, you can use it PROPER function in Excel.