Make Google Sheets Text Uppercase With UPPER

In Google Sheets, use the UPPER function to convert a text value to uppercase. If the original text is in A2, enter =UPPER(A2) in a different cell, such as B2. The result appears in the helper cell while the original remains available for comparison.

Start with one cell and one formula

Google’s UPPER documentation defines the function as a text-to-uppercase conversion. For a simple example, put project status in A2 and =UPPER(A2) in B2. The expected result is PROJECT STATUS.

Do not put =UPPER(A2) into A2 itself. That formula would refer to its own cell instead of preserving a source-and-result pair. Using a separate helper column makes the transformation visible and gives you a place to inspect the result before replacing anything.

Compare several ordinary values

These examples isolate letter case. The digits, hyphen, spaces and punctuation remain part of the values. UPPER does not trim whitespace, split words into columns or repair a spelling mistake; add a separate, deliberate cleanup step only when the data requires it.

If a source contains leading or trailing spaces, inspect those independently. A value can be fully uppercase and still fail a lookup because of an extra space. Changing case and changing whitespace solve different problems.

Fill a bounded helper column

After checking B2, fill the formula down through the intended data rows. Relative references should advance from A2 to A3 and A4 in the following rows. Inspect a cell near the end of the filled range to confirm that it references the matching source row.

A formula such as =UPPER($A$2) keeps referring to A2 because the reference is fixed. That can be useful for a deliberate constant, but it is wrong for converting a different contact or product name in every row. Repeated identical output is a reason to inspect the references before blaming the case function.

Keep headers and blank rows intentional

Start below the header when the header should remain unchanged. Limit the fill to the relevant data range so that the helper column does not become an unexplained continuation far below the table. If the source list contains blank rows, decide whether they are meaningful separators or accidental gaps.

For a workflow that explicitly keeps blank source cells blank, a formula such as =IF(A2="","",UPPER(A2)) makes that intent visible. Formula argument separators can vary with spreadsheet locale, so follow the syntax accepted by your sheet. This condition treats a cell containing only spaces differently from a truly empty string.

Choose formulas or fixed values

A helper formula updates when its source changes. Keep it when you want that relationship to continue. If you need an independent final text column, copy the reviewed results and use the sheet’s values-only paste option in the intended destination range.

Check the pasted cells before removing the source or helper column. A normal formula paste can retain references instead of producing fixed text. Deleting a referenced source prematurely can therefore break results that looked correct a moment earlier.

Avoid changing case-sensitive identifiers blindly

Display labels are different from passwords, tokens, code identifiers and some external record keys. Uppercasing a label may be a formatting requirement; uppercasing a key may change which record it refers to. Confirm the destination’s rule before transforming values used for matching or authentication.

Likewise, uppercase does not preserve the original mixed-case spelling. Turning McDonald into MCDONALD and then applying LOWER does not reconstruct McDonald. Retain the original column when the source spelling has value.

Check the final table as a table

Compare two distinct rows and a row containing punctuation or digits. Keep source and result rows aligned when sorting. Sorting only one column can associate an uppercase name with another record’s details even though every UPPER formula was correct.

Test the formula on two source rows in your own sheet before replacing a larger range of data. For a plain-text alternative, the Uppercase Converter changes supplied text in the browser; it does not update spreadsheet cells or preserve spreadsheet formulas.

Related guides

Upper Case Character Meaning

Learn upper case character meaning: practical steps plus final checks for meaning, Unicode, whitespace and destination formatting.

Upper Case And Lower Case Meaning

Use this guide for upper case and lower case meaning; it explains the workflow and how to verify meaning, Unicode, whitespace and destination formatting.

Upper Case Alphabet Example

Solve upper case alphabet example with a focused sorting lists & line tools workflow and final checks for meaning, Unicode.