The TRIM function

Removes extra spaces from text.

In German Excel: GLÄTTEN

How to write it

=TRIM(text)

text: The text to clean.

💡 It also turns double spaces between words into single ones.

Try it

Remove the extra space from the city in B2.

D2

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 removes spaces at the start and end.