Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
UPPER
UPPER transforms every letter in a text string to its uppercase equivalent, leaving numbers and symbols unchanged. Use it to standardize text for comparisons, headings, identifiers, or any scenario where consistent capitalization is required.
Excel
=UPPER(A2)Google Sheets
=UPPER(A2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| ProductCode |
| widget-a |
| gadget-b |
| doohickey-c |
| thingamajig-d |
=UPPER(A2)→WIDGET-A
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Identify the cell containing the text you want to convert.
- 2Enter =UPPER(text) referencing that cell.
- 3Copy the formula down the column to apply to all rows in your dataset.
Need a version for your data?
Try: “Convert all product codes in a column to uppercase for standardization”