Skip to main content

Clean customer names with TRIM and PROPER

83%
PROPERTRIM

Names imported from another system often contain leading spaces, trailing spaces or several spaces between words. TRIM removes the extra spacing without changing the letters.

PROPER then capitalises the first letter of each word. Nesting PROPER around TRIM lets one formula clean both problems, and the result follows the raw name if it is corrected later.

In B2:B5, use a formula combining TRIM and PROPER to clean all four customer names.

The grid for this exercise needs a free profile.

Everything above is yours to read either way. 19 exercises stay open with no profile at all.

Adapted from Excel Beginners Practice Lab by Muhammad Auwal Abdulaziz (MIT).