PlayInfoBox

Home /Utilities /How to Use UPPER, LOWER, and PROPER in Excel

How to Use UPPER, LOWER, and PROPER in Excel

Tap through each step to convert text case in Excel.

  1. Use UPPER to convert everything to uppercase

    Typing "=UPPER(A1)" converts every letter in the text to uppercase.

  2. Use LOWER to convert everything to lowercase

    Typing "=LOWER(A1)" converts every letter in the text to lowercase.

  3. Use PROPER to capitalize just the first letter of each word

    Typing "=PROPER(A1)" capitalizes the first letter of each word and lowercases the rest.

  4. Combine it with TRIM

    Wrapping the result in TRIM, which removes extra spaces, cleans up the data even further.

  5. Why it is useful

    It is useful for standardizing inconsistent capitalization in data like email addresses or names typed in mixed case.

These functions don't change the original cell

UPPER, LOWER, and PROPER return a new value in whichever cell holds the formula β€” they don't overwrite the source text in place. If you want to permanently replace the original data with the converted version, copy the result and paste it back as a value only, leaving the formula behind.

Useful before comparing or matching text

Because manually entered data often mixes cases inconsistently, normalizing everything to one case first with these functions makes visual review, sorting, and exact-match comparisons noticeably more reliable.

Frequently Asked Questions

Do UPPER, LOWER, and PROPER work on numbers or dates in a cell?

No β€” they only affect letters within text. Numbers and dates pass through unchanged since there's no letter case for them to convert.

Why does PROPER capitalize names like McDonald or O'Brien awkwardly?

PROPER capitalizes the first letter after any space or non-letter character, so it has no way of knowing that "Mc" or a name after an apostrophe should keep a second capital letter β€” results like "Mcdonald" often need manual correction afterward.