ExcelHeroThe PROPER function
Capitalises the first letter of every word.
In German Excel: GROSS2
How to write it
=PROPER(text)- text
- The text to fix.
💡 Use TRIM first to clean spaces: =PROPER(TRIM(A2)).
Try it
Write the name in A3 with only the first letters capital.
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
PROPER makes “Every Word Like This”.