Excel functions

The UPPER function

Converts text to capital letters.

Syntax

UPPER(text)

text: The text to convert.

Examples

C1=UPPER(A2)

	A	B	C
1	Code		DK-2100
2	dk-2100

C1=UPPER("copenhagen")

	A	B	C
1	Code		COPENHAGEN
2	dk-2100

Practice UPPER

Read the guide

Related functions