UPPER, LOWER, PROPER in Excel - Step-by-Step Guide

Introduction

These functions help you change the case of text in your spreadsheet. UPPER makes all letters capital, LOWER makes all letters small, and PROPER capitalizes the first letter of each word. This is useful when you want your text to look neat and consistent.

When you receive a list of names in all lowercase and want to capitalize the first letter of each name.

When you have product codes in mixed case and need them all in uppercase for consistency.

When you want to convert email addresses to lowercase to avoid case sensitivity issues.

When preparing a mailing list and want all names to appear in proper case for a professional look.

When cleaning up data imported from other sources that have inconsistent text casing.

Steps

Step 1: Click

- cell where you want the result

The cell is selected and ready for input

Step 2: Type

- the selected cell

The formula appears in the cell and formula bar

💡 Start formulas with an equal sign (=)

Step 3: Enter formula =UPPER(A1)

- the selected cell

The text from cell A1 appears in uppercase in the selected cell

Step 4: Enter formula =LOWER(A1)

- another cell

The text from cell A1 appears in lowercase in that cell

Step 5: Enter formula =PROPER(A1)

- another cell

The text from cell A1 appears with the first letter of each word capitalized

Step 6: Press Enter

- formula cell

Formula calculates and shows the converted text

Before vs After

Before

Cell A1 contains text: "john doe"

After

Using =UPPER(A1) shows "JOHN DOE", =LOWER(A1) shows "john doe", =PROPER(A1) shows "John Doe"

Settings Reference

Formula input

📍 Formula bar or cell

To convert text case as needed

Default: No default, user types formula

Common Mistakes

Typing the text directly inside the formula without quotes

Excel expects text strings inside quotes or a cell reference

Use =UPPER("john doe") or =UPPER(A1) if text is in cell A1

Forgetting the equal sign (=) before the formula

Excel treats it as plain text, not a formula

Always start formulas with =, for example =LOWER(A1)

Summary

UPPER, LOWER, and PROPER change text case to uppercase, lowercase, and proper case respectively.

Use these functions to clean and standardize text data easily.

Remember to start formulas with = and use cell references or quoted text.