Text·Lesson 35 of 62Pro
How to use PROPER in Google Sheets
Fix capitalisation
How PROPER works
PROPER capitalises the first letter of every word. UPPER and LOWER change all letters.
PROPER(text)
Example on this data
=UPPER(A3)→JAMES CHEN
UPPER works the same way: every letter capitalised.
What you’ll do
You’ll clean up a name and give each word a capital letter. Tidy names make mail merges and reports look professional.
Try it
Type =UPPER(A3) into G2 and press Enter. Watch what the sheet does.
The result will appear in G2.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Full name | SKU | Note | ||||
| 2 | maria lopez | maria.lopez@acme.com | WID-2041-BLU | Call back 555-0142 | |||
| 3 | james chen | jchen@northwind.io | GAD-1180-RED | Sent invoice | |||
| 4 | Priya Shah | priya@shahdesign.co | WID-3307-GRN | Call back 555-0199 | |||
| 5 | tom o'neil | tom.oneil@acme.com | BOX-0042-BLU | Left voicemail | |||
| 6 | Lena Park | lena.park@globex.com | GAD-2215-BLK | Call back 555-0107 | |||
| 7 | sam reed | sreed@northwind.io | WID-0918-RED | Meeting Tue |
Ctrl+/ shows the shortcuts
Drill locked
Unlock the other 44 lessons for $49.99
You’ve seen how PROPER works. Pro lets you write it yourself on real data and get checked instantly, with practice sets and section reviews for every lesson.
Your drill
In G2, show the name in A2 trimmed and with each word capitalised.
One payment, no subscription.