The Excel Upper function converts all characters in a supplied text string to upper case.
The syntax of the function is:
Where the text argument is the original text string, that you want to convert to upper case.
Column B of the following spreadsheet shows the Excel Upper function, used to convert four text strings to upper case:
Further details and examples of the Excel Upper function are provided on the Microsoft Office website.