Learn how PROPER, UPPER, LOWER, and TRIM transform text in Excel, from changing letter case to removing extra spaces.
PROPER function
Capitalizes the first letter of every word in the cell.
=PROPER(text)
UPPER function
Capitalizes every letter in the cell.
=UPPER(text)
LOWER function
Formats each letter in a cell as lowercase.
=LOWER(text)
TRIM function
Removes excess spaces from the contents of a cell.
=TRIM(text)
Continue Learning Excel
Practice spreadsheet skills in Excel classes, explore Microsoft Office training, or discuss training for your team.