How To Use Excel UPPER Function

    how to use excel upper function

    Quick Intro

    Use Excel UPPER Function to convert a normal text into upper case text. In simple words, It will convert normal text case into a text in which all the letters are in upper case.

    For example, “excelchamps” will be converted into “EXCELCHAMPS”.

    Syntax

    UPPER(text)

    text A text string which you want to convert into upper case.

    More Information on Excel UPPER Function

    • Characters other than alphabets will remain unchanged.
    • If referred text contains an error it returns an error in the result.
    • You can also insert text string directly into the function by using double quotation marks.

    Examples

    As I said, in an upper case text we have all the letters in capital form.

    Compare Excel UPPER Function With Other Cases

    In the below example, I have used the upper function to convert name text to capital letters from the text in which characters are in different cases.

    Use Excel UPPER Function To Convert Lower Case Name Into Upper Case

    In above example, I have used the upper function to convert name text to capital letters from the text in which characters are in different cases.

    You can also use it to convert normal text case into sentence case.

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel UPPER Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

    There are also you have LOWER | PROPER functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.