Google Sheets | UPPER Function | Convert Lowercase Text to Uppercase | Spreadsheet Tutorial

Published: 22 March 2022
on channel: Software Spring

9,646

Use the Google Sheets UPPER function to convert lowercase text into uppercase.

Let's look at the format of UPPER function formula:

=UPPER(text)

-------------------------------------
Google Sheets Quiz with Demo of Answers

Try this 5-question quiz, which also demos the answers. The quiz
can be helpful in your day-to-day spreadsheet work or for job interview:

   • Google Sheets Functions Quiz | Fill-i...

IFNA Function

Here is the link to the step-by-step tutorial for using the IFNA function for
displaying a custom message with the #N/A error:

   • Google Sheets | IFNA Function | Displ...

MATCH Function

If you wish to find the position of an item in a list, the MATCH function can
be helpful. Here is the link to the step-by-step tutorial on MATCH:

   • Google Sheets Match | Match Function ...
-------------------------------------

Start the formula with an equal-to symbol.

UPPER is the name of the function.

text is the text to convert to upper-case. text can be, for example, a hard-coded value between double-quotes or a cell address.

Here are examples of the UPPER function formula:

Example

=UPPER("low inventory")

The formula will return LOW INVENTORY.

Example

Assume that cell B3 has the text "payment due".

The formula

=UPPER(B3)

will return PAYMENT DUE.

Take a look at this video tutorial, which gives the steps to use the Google Sheets UPPER function with examples.