Normalise a SKU
| A | |
|---|---|
| 1 | SKU |
| 2 | sku-77a |
Formula: C2: =UPPER(A2)
Result: SKU-77A
Letters change to capitals while the digits and the hyphen stay as they are.
Google Sheets function
UPPER in Google Sheets
UPPER handles one cell at a time, so ARRAYFORMULA(UPPER(A2:A)) is the Google Sheets way to convert the entire column from one formula.
Syntax (same in Google Sheets)
UPPER(text)The open-ended A2:A reference includes rows added later.
For a fuller explanation of the arguments and common errors, see the UPPER Excel guide.
Worked examples in Google Sheets
Capitalise only the first letter
| A | |
|---|---|
| 1 | Word |
| 2 | spreadsheet |
Formula: C2: =UPPER(LEFT(A2,1))&MID(A2,2,50)
Result: Spreadsheet
LEFT takes the first letter, UPPER capitalises it and MID appends the remainder.
Case-insensitive comparison
| A | B | |
|---|---|---|
| 1 | Entered | Expected |
| 2 | yes | YES |
Formula: D2: =UPPER(A2)=UPPER(B2)
Result: TRUE
Converting both sides to capitals removes any difference caused by case.
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in D2: =UPPER(A2)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Text | Other | Result | |
| 2 | Alice Johnson | alice johnson | ALICE JOHNSON | |
| 3 | [email protected] | [email protected] | ||
| 4 | extra spaces | |||
| 5 | SKU-2026-0415 | |||
| 6 | iced coffee, tea, sugar | |||
| 7 | Order 417 shipped |
Result in D2: ALICE JOHNSON
Frequently asked questions
- How do I convert a whole column to capitals in Google Sheets?
- Put =ARRAYFORMULA(UPPER(A2:A)) in the first cell of an empty column. New rows added to column A are converted too.
Google Sheets is used here only as a descriptive product name. FormulaCamp is not affiliated with Google.