PROPER practice

PROPER capitalizes the first letter of each word in a text. Below are the 1 Google Sheets exercise on Sheetsdrill 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.

Google Sheets exercise that use PROPER

• Tidy up pasted namesLevel 5Pro

Often used together with: TRIM