Formulas > =UPPER()
How To Use UPPER() Function in Google Sheets
Description
How To Actually Use UPPER() in Sheets
UPPER(text)
Try UPPER yourself
In cells B1:B10, use the UPPER() formula to convert the text in cells A1:A10 to uppercase. The result should display the uppercase version of each corresponding text.
Hints (2)
-
Remember to reference the correct cell in your formula.
-
You can drag the formula down to apply it to other cells.
6 Better Sheets Tutorials
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?
ARRAYFORMULA()
LOWER()
PROPER()
UPPER()
Capitalize Each Word
Every word can be capitalized with this formula.
LOWER()
PROPER()
UPPER()
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.
ARRAYFORMULA()
FILTER()
UPPER()
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.
CONCATENATE()
ROUNDDOWN()
UPPER()
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.
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.
ARRAYFORMULA()
COUNTIF()
LOWER()
SORT()
UNIQUE()
+1 more
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.
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.
IF()
LOWER()
PROPER()
UPPER()
Learn more about the UPPER() formula:
Generate a UPPER() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses UPPER(). 2 free AI generations, no signup. Members get unlimited use.
Generate a UPPER() formula