The Excel Upper function converts all characters in a supplied text string to upper case.
The format of the function is :
Where the text argument is the original text string, that you want to convert to upper case.
The spreadsheet below shows four examples of the Upper function.
The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right.
Further information and examples of the Excel Upper function are provided on the Microsoft Office website.