the UPPER function is a text function that is used to convert all the letters in a text string to uppercase. This can be useful in various situations where you need to ensure that text is consistently in uppercase format, regardless of how it was originally entered.
Syntax
=UPPER(text)
text: This is the text string that you want to convert to uppercase. It can be a reference to a cell containing text or a text string enclosed in double quotation marks.
Example
