Skip to content

Change text case

Convert names to Proper Case, or any text to UPPER or lower case.

The formula

Argument separator
Excel and Google Sheets
=PROPER(TRIM(A2))

How it works

  1. PROPER(…)

    Capitalises the first letter of each word. Use UPPER or LOWER for other styles.

  2. TRIM(A2)

    Removes stray spaces first.

Example

A: RawB: Result
jOHN smithJohn Smith
ANNA-LENA KOCHAnna-Lena Koch

Tips

  • PROPER also capitalises after apostrophes, so "o'neil" becomes "O'Neil" but "it's" becomes "It'S". Check edge cases.