Google Sheets is a powerful spreadsheet that lets you use formulas to accomplish many things.
One such group of formulas allows you to change the text cases inside cells for whatever purpose.
Here’s how you’ve got the option to use it.
What Is the UPPER Function?
As a text function, UPPER will only work on text strings in your cells.
Think of it as using an algebraic expression where you substitute values into the formula.
It changes the text in a string to all capital letters.
Additionally, that one argument can only be a cell reference or a text string.
Utilizing the UPPER function will allow you to avoid manually capitalizing each letter in the text.
Instead, the built-in function will effortlessly convert each character throughout the text to an uppercase version.
This can be helpful if you want to make a cell stand out without using conditional formatting.
Below is a step-by-step illustration of the process.
you’ve got the option to follow the steps from the first example to use the UPPER function.
We’ve provided an example below to show how it works.
you could apply the formula to more than one cell with the fill handle.
Google Sheets may alsosuggest an autofillto make your life easier.
But, both of these methods are a little slower than nesting the UPPER function with an ARRAYFORMULA.
That’s why you have to use an ARRAYFORMULA.
To usethe ARRAYFORMULA function in Google Sheets, you must nest the same formula inside it.
it’s possible for you to also nest the UPPER function in Google Sheets with numerous other formulae.
Doing so will make the final answer come out in all capitals.
