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.
Further information and examples of the Excel Upper function are provided on the Microsoft Office website.