Excel Function Translator Logo
    The Excel Translator

    UPPER

    Text

    Converts all letters in a text string to uppercase.

    Translations
    EnglishUPPER
    FrenchMAJUSCULE
    SpanishMAYUSC
    GermanGROSS
    ItalianMAIUSC
    PortugueseMAIÚSCULA
    DutchHOOFDLETTERS
    PolishLITERY.WIELKIE
    RussianПРОПИСН
    TurkishBÜYÜKHARF
    CzechVELKÁ
    HungarianNAGYBETŰS
    SwedishVERSALER
    DanishSTORE.BOGSTAVER
    FinnishISO
    Syntax
    UPPER(text)

    Arguments

    • textThe text to convert to uppercase
    Examples
    =UPPER("hello")
    HELLO

    Converts to all caps

    =UPPER(A1)
    UPPERCASE A1

    Uppercases cell content

    =UPPER(A1)=A1
    TRUE if already upper

    Tests if already uppercase

    Tips & Best Practices
    • •Non-letter characters are unchanged
    • •Use LOWER for all lowercase
    • •Use PROPER for Title Case
    Common Mistakes
    • •Using UPPER expecting it to also fix inconsistent spacing or spelling - it only changes the letter case, nothing else
    • •Applying UPPER in a formula and expecting the source cell to update - it only affects the display in the formula cell, not the original data
    • •Assuming UPPER might affect numbers or symbols in mixed content - it only changes letters, everything else passes through unchanged
    Related Functions
    LOWERConverts text to all lowercase instead of all uppercase
    PROPERCapitalizes just the first letter of each word instead of the whole thing
    EXACTCase-sensitive comparison, often used to check if two values already match in case before converting
    Frequently Asked Questions

    Does UPPER change the actual data in the source cell?

    No, UPPER only affects the cell where the formula lives. To replace the original, copy the result and paste as values back over the source.

    Can UPPER convert an entire column at once?

    Not directly in the source column, but you can apply it in a helper column, then paste the results as values back over the original.

    Does UPPER affect numbers or symbols in the text?

    No, only letters are affected. Numbers, punctuation, and symbols pass through unchanged.

    Need to translate a formula using UPPER?

    Use our translator to convert your complete formula