How to Use Excel UPPER Function (Examples + Video)

Excel UPPER Function (Example + Video)

Excel UPPER Function

When to use UPPER Function

UPPER function can be used when you want to convert all lowercase letter in a text string to uppercase.

What it Returns

It returns a text string where all lowercase letter have been converted into uppercase.

Syntax

=UPPER(text)

Input Arguments

  • text – the text string that you want in uppercase.

Additional Notes

  • Characters that are not letters remain unchanged.
    • Numbers and punctuations remain unaffected.

Excel UPPER Function – Live Example

Excel UPPER Function – Video Tutorial

Related Excel Functions: