‍

In this article, you will learn how to make capitalized letters with the UPPER function in Google Sheets. This formula is helpful when you need to make all letters capitalized across a data set.

‍

‍

How to make capital letters in Google Sheets

‍

• Type “=UPPER(” or go to “Insert” → “Function” → “Text” → “UPPER”.

‍

• Input a text value by cell reference or manual input.

‍

• Press the “Enter” key.

‍

‍

   Your next financial spreadsheet could be right here!

   100+ spreadsheet templates, from FP&A to tax planning.

   Free Spreadsheet Templates

‍

The generic syntax is as follows:

‍

=UPPER(text)

=UPPER(text)

=UPPER(text)

=UPPER(text)

‍

Text: This is a text string in which you make a change.

‍

See the following examples. Whatever cases of all letters in a selected text string, the UPPER formula makes all letters uppercase. The last example shows manual input of a text value, “abc”.

‍

‍

‍

How do you capitalize all first letters in sheets?

‍

You can use the PROPER function. If you want to learn about the formula, check this article. If you are also interested in make all letters lowercase, read this post.

‍

   Learn how LiveFlow can save you hours a month on financial reporting!

   Just 30 minutes can change the way your business operates forever.

   Book a Demo

‍