UPPER, LOWER, PROPER in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a customer service analyst at an online retail company.

📋 Request: Your manager wants a clean and consistent customer name list for mailing labels. The names are currently in mixed cases.

📊 Data: You have a list of customer names in column A with inconsistent capitalization.

🎯 Deliverable: Create three new columns showing the names in all uppercase, all lowercase, and proper case formats.

Sample Data

Customer Name
john doe
MARY SMITH
alice Johnson
roBERT brown
EMILY davis
michael CLARK
Linda MARTIN
george hARRIS

1

Step 1: Insert a new column B and label it 'Uppercase'. In cell B2, enter the formula to convert the customer name in A2 to all uppercase letters.

=UPPER(A2)

Expected Result

JOHN DOE

2

Step 2: Copy the formula in B2 down the column to apply it to all customer names.

Drag the fill handle from B2 down to B9

Expected Result

All names in column B appear in uppercase, e.g., MARY SMITH, ALICE JOHNSON

3

Step 3: Insert a new column C and label it 'Lowercase'. In cell C2, enter the formula to convert the customer name in A2 to all lowercase letters.

=LOWER(A2)

Expected Result

john doe

4

Step 4: Copy the formula in C2 down the column to apply it to all customer names.

Drag the fill handle from C2 down to C9

Expected Result

All names in column C appear in lowercase, e.g., mary smith, alice johnson

5

Step 5: Insert a new column D and label it 'Proper Case'. In cell D2, enter the formula to convert the customer name in A2 to proper case (first letter capitalized).

=PROPER(A2)

Expected Result

John Doe

6

Step 6: Copy the formula in D2 down the column to apply it to all customer names.

Drag the fill handle from D2 down to D9

Expected Result

All names in column D appear in proper case, e.g., Mary Smith, Alice Johnson

Final Result

Customer Name | Uppercase     | Lowercase     | Proper Case
---------------------------------------------------------
john doe      | JOHN DOE     | john doe      | John Doe
MARY SMITH    | MARY SMITH   | mary smith    | Mary Smith
alice Johnson | ALICE JOHNSON| alice johnson | Alice Johnson
roBERT brown  | ROBERT BROWN | robert brown  | Robert Brown
EMILY davis   | EMILY DAVIS  | emily davis   | Emily Davis
michael CLARK | MICHAEL CLARK| michael clark | Michael Clark
Linda MARTIN  | LINDA MARTIN | linda martin  | Linda Martin
george hARRIS | GEORGE HARRIS| george harris | George Harris

✓The UPPER formula converts all letters to uppercase for uniformity.

✓The LOWER formula converts all letters to lowercase for consistency.

✓The PROPER formula capitalizes the first letter of each word, ideal for names.

Bonus Challenge

Create a new column that combines the first name in proper case and the last name in uppercase, separated by a comma.

Show Hint

Use PROPER and UPPER with text functions like SPLIT or LEFT/RIGHT to separate first and last names.