UPPER, LOWER, PROPER in Google Sheets - Dashboard Guide

Dashboard Mode - UPPER, LOWER, PROPER

Dashboard Goal

This dashboard helps you clean and standardize names by changing text to all uppercase, all lowercase, or proper case (first letter capitalized).

Sample Data

Original Name
alice johnson
BOB SMITH
cHaRLie bRoWn
diana prince
eVa GREEN

Dashboard Components

• Uppercase Names: Converts all letters to uppercase.
  Formula example: =UPPER(A2) applied to each name.
  Result for 'alice johnson' is 'ALICE JOHNSON'.
• Lowercase Names: Converts all letters to lowercase.
  Formula example: =LOWER(A2) applied to each name.
  Result for 'BOB SMITH' is 'bob smith'.
• Proper Case Names: Capitalizes the first letter of each word.
  Formula example: =PROPER(A2) applied to each name.
  Result for 'cHaRLie bRoWn' is 'Charlie Brown'.

Dashboard Layout

+-------------------+-------------------+-------------------+
| Original Name     | Uppercase Names   | Lowercase Names   |
+-------------------+-------------------+-------------------+
| alice johnson     | ALICE JOHNSON     | alice johnson     |
| BOB SMITH         | BOB SMITH         | bob smith         |
| cHaRLie bRoWn    | CHARLIE BROWN     | charlie brown     |
| diana prince      | DIANA PRINCE      | diana prince      |
| eVa GREEN         | EVA GREEN         | eva green         |
+-------------------+-------------------+-------------------+

+-------------------+
| Proper Case Names  |
+-------------------+
| Alice Johnson     |
| Bob Smith         |
| Charlie Brown     |
| Diana Prince      |
| Eva Green         |
+-------------------+

Interactivity

You can add a filter to select specific names (for example, filter by names containing 'a'). When you filter the original names, the uppercase, lowercase, and proper case columns update automatically to show only the filtered names.

Self Check

If you add a filter to show only names containing the letter 'e', which names appear in the Proper Case Names column?

Answer: 'alice johnson', 'diana prince', and 'eVa GREEN' appear as 'Alice Johnson', 'Diana Prince', and 'Eva Green'.

Key Result

Dashboard to convert names into uppercase, lowercase, and proper case for easy text cleaning.