The UPPER function

Turns text into capitals.

In German Excel: GROSS

How to write it

=UPPER(text)

text: The text.

💡 LOWER does the opposite.

Try it

Write the city in B3 in capitals, without the extra space.

D3

A

B

C

D

1

Full name

City

Code

Clean

2

maya lopez

berlin

TS-1042-BLU

3

LEO KING

paris

HD-0077-RED

4

sam o’neil

Rome

MG-3150-GRN

Trim first, then UPPER.