UPPER

Converts the letters of a given string to uppercase. To convert text to lowercase please refer to LOWER.

Syntax

=UPPER(Text)

Arguments

Name

Description

Text

A string to convert to uppercase

Return Value

Given text in uppercase.

Example

Function

Result

Comment

=UPPER(“nIcE 4 u!”)

NICE 4 U!

only affects letters in lowercase

=UPPER(A1)

HELLO WORLD

assumes cell A1 contains text “hello world”