UPPER, LOWER, PROPER in Google Sheets - Step-by-Step Guide

Introduction

These functions 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. They help clean up or format names, addresses, and other text data.

When you receive a list of names typed in different cases and want them all to look consistent.

When you want to make email addresses all lowercase for easier comparison.

When you have a list of book titles or addresses and want each word to start with a capital letter.

When you want to quickly fix text copied from other sources that have mixed uppercase and lowercase letters.

When preparing data for reports that require proper text formatting.

Steps

Step 1: Click

- a blank cell where you want the result

The cell is selected and ready for input

Step 2: Type

- the formula bar

The formula appears in the cell and formula bar

💡 Start formulas with an equal sign (=)

Step 3: Enter

- the formula =UPPER(A1)

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

Step 4: Repeat

- for LOWER and PROPER functions using =LOWER(A1) and =PROPER(A1)

The text from cell A1 appears all lowercase or with each word capitalized, respectively

Step 5: Drag

- the fill handle (small square at bottom-right of the cell)

The formula copies down to other cells, applying the case change to each corresponding cell

Before vs After

Before

Cell A1 contains 'john doe', Cell A2 contains 'HELLO WORLD', Cell A3 contains 'mArY aNn'

After

Using =UPPER(A1) shows 'JOHN DOE', =LOWER(A2) shows 'hello world', =PROPER(A3) shows 'Mary Ann'

Settings Reference

Formula input

📍 Formula bar

To convert text case in the selected cell

Default: No default, you must type the formula

Common Mistakes

Typing the text directly inside the formula without quotes

Google Sheets expects text strings inside quotes or a cell reference

Use =UPPER("text") or =UPPER(A1) where A1 contains the text

Forgetting the equal sign (=) before the function

Without =, Google Sheets 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 capitalized words.

Use these functions to clean and standardize text data easily.

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