Excel Study · Module 5: Text functions
Class 42UPPER, LOWER & PROPER
Intermediate1:42 videoFree
Names typed in a hurry come in random capitals. UPPER turns every letter into a capital, LOWER turns every letter small, and PROPER gives a capital at the start of each word and small letters for the rest: =PROPER(A2) turns mEI lIN into Mei Lin.
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A5 has a name typed in random capitals. Write a formula for D7 that shows the name from A5 with a capital letter at the start of each word and the rest in small letters.
The answer that works
✓ checked in Excel=PROPER(A5)
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.