PROPER practice

PROPER capitalizes the first letter of each word in a text. Below are the 3 Excel exercises on Formuladrill that use it, each checked instantly in your browser.

Syntax

PROPER(text)

What people get wrong

Combine with TRIM to clean up names typed in capitals or with stray spaces.

Excel exercises that use PROPER

• Clean up namesLevel 4Pro
• Clean the customer namesLevel 6Free
• Sales by region with messy labelsLevel 6Pro

Often used together with: SUMIF, TRIM