fx =PROPER(A1)ABCJohnSmithJohn SmithJaneDoeJane DoeAlexWongAlex Wong
📝 Text

UPPER / LOWER / PROPER Formula for Text Manipulation

Change text case. Copy-paste ready for Excel, Google Sheets, and Airtable.

=PROPER(A1)
When you need this: When you import messy customer names ("john smith" or "JOHN SMITH") and need them properly formatted ("John Smith").

How it works

  1. 1UPPER converts all text to UPPERCASE.
  2. 2LOWER converts all text to lowercase.
  3. 3PROPER capitalizes the first letter of each word (Title Case).

Variations

Combine TRIM and PROPER
=PROPER(TRIM(A1))
UPPER for data codes
=UPPER(A1)

Related Formulas

CONCATENATE / TEXTJOIN — Join text from multiple cellsTextLEFT / RIGHT / MID — Extract part of a text stringTextLEN — Count the number of characters in textTextTRIM — Remove extra spaces from textText

Need a formula that's not here?

Generate custom formula →