UPPER Function

About

UPPER function in Excel is used to convert the small letters into capital letters.

Function Type

Text

Purpose

Convert text into upper case.

Return value

Upper case version of the text

Syntax

=UPPER(text)

Arguments

text – text string to be converted into upper case


Example


Notes

UPPER function ignores numbers.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel