Better Sheets

Academy ↓

Free ↓

Login
Get Instant Access

Formulas > =UPPER()

How To Use UPPER() Function in Google Sheets

Description

Converts a specified string to uppercase.

Common questions about the UPPER formula in Google Sheets:
What does the UPPER formula do?
How do I use the UPPER formula in Google Sheets?
Can the UPPER formula convert a range of cells to uppercase?
Does the UPPER formula only work with alphabetic characters?
Can I use the UPPER formula with non-English characters or special symbols?

Appropriate use of the UPPER formula:
Converting text to uppercase: The primary purpose of the UPPER formula is to convert text to uppercase. It is commonly used when you want to standardize the case of text or when case sensitivity is not important.

Common mistypings of the UPPER formula:
Misspelling: One common mistyping is misspelling the formula as "UPPERCASE" instead of "UPPER."

Inappropriate use of the UPPER formula:
Incorrect assumptions about case sensitivity: Using the UPPER formula to compare text for equality may lead to incorrect results. The formula converts the text to uppercase but does not change the underlying data. So, comparing text using the UPPER formula may not yield accurate results in all cases.

Common pitfalls when using the UPPER formula:
Overwriting original data: Applying the UPPER formula directly to a range of cells will overwrite the original text with the uppercase version. If you need to preserve the original text, it's important to use the formula in a separate column or store the uppercase version in a different location.

Common mistakes when using the UPPER formula:
Applying the formula to numbers or dates: The UPPER formula is designed to work with text values. If you apply it to numbers or dates, you'll get an error or unexpected results.

Common misconceptions about the UPPER formula:
Changing the underlying data: The UPPER formula only converts the text to uppercase for display purposes. It does not permanently change the case of the underlying data. Some users may mistakenly believe that applying the UPPER formula will modify the original data.
Automatic real-time updates: The UPPER formula does not automatically update the uppercase version if the original text changes. It is a one-time transformation and needs to be reapplied if the original text is modified.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you. 

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At bettersheets.co/formulas, I have everything you need to take your Google Sheets skills to the next level. 
From ARRAYFORMULA() to ZTEST(), Better Sheets has it all. 

How To Actually Use UPPER() in Sheets

UPPER(text)
Google Docs Help

6Better Sheets Tutorials

Build a Case Converter From Scratch
Create a little web app, or a tool inside of Google Sheets that can take any text input and give us the correct case we want. It can do Title Case or Sentence Case. It can do UPPER and lower case as well.

I added a little apps script to it that will check only one of the options. Check out the Radio Button Apps Script in another video.
Intermediate
How to Make a Marketplace in a Google Sheet
Make a marketplace where sellers and buyers do not have to have edit access to a sheet.
Intermediate
Benoit Asks: How to Convert Case
How can I use this function, lower, upper, or proper as a conditional formatting? And then the other question is, how can I use this to apply on a bunch of cells without having to double the cells?
Discover Misspelled Duplicates
Discover effective methods to handle misspelled duplicates in Google Sheets using formulas without destroying your data. Search and find duplicates that are spelled differently.

Unveiling the Art of Taming Misspelled Duplicates: A Harmonious Symphony of Google Sheets Tricks and Tips

Embark on a captivating journey as we unravel enchanting secrets in this video guide.

Discover an ethereal dance of formulas that transcends the limitations of Google Sheets' native features, gracefully addressing the conundrum of misspelled duplicates. 

Delve into the profound intricacies of the issue, where statuses and names intertwine, inviting chaos into your CRM or meeting records. 

Witness the mesmerizing revelation of unorthodox yet elegant techniques that preserve your data's essence without sacrificing its integrity. Unveil the hidden world of the duplicate detector, where rows are harmoniously synchronized, leaving no spelling errors unnoticed. 

Prepare to be enchanted by the sublime artistry of equals unique, a symphony of transformation that transforms hundreds or thousands of rows into a carefully curated masterpiece. Immerse yourself in this poetic quest and unlock the mystique of finding truth amidst a sea of missteps.
Beginner
Create an Email Campaign Stats Calculator
Take your email marketing to the next level with our Google Sheet Campaign Stats Calculator. Analyze open rates, click-throughs, and conversions, and make data-driven decisions to improve your campaigns. Build a sheet from scratch. We're going to build a calculator, with some functions and some custom functions in apps script. We'll also design the sheet like a funky dashboard.
Advanced
Capitalize Each Word
Every word can be capitalized with this formula.

Learn more about the UPPER() formula:

Capitalize Each Word in google sheets, Called Proper or Title Case or Sentence Case

This is how to make each word in sentence capitalized. It's called Title Case often, but in Google sheets it's called Proper.

Generate a UPPER() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.

Asa

Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.

Better Sheets

Something for everyone to Learn Google Sheets. Includes Google Sheets for Beginners and Advanced Google Sheets Tutorials alike.

Get Started Now

Google Sheets Help

Google Sheets Courses

Google Sheet Templates and Tools

Google Sheet Add Ons