FormulaCraft

PROPER / UPPER / LOWER

PROPER capitalises the first letter of each word, UPPER makes everything uppercase, and LOWER makes everything lowercase. Use them to standardise messy text.

Excel
=PROPER(A2)
Google Sheets
=PROPER(A2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2 is the text to reformat.
  2. 2PROPER title-cases it; UPPER and LOWER force one case.
  3. 3Paste the result as values to replace the originals.

Need a version for your data?

Try: “Capitalise the first letter of each word in the name in A2”

Related

TEXTJOINLEFT / RIGHT / MIDTRIM

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: