top of page

How to All Caps in Google Sheets

Updated: Jul 6, 2023

Ever wondered if you can change text to all capital letters in Google Sheets? The answer is yes! In this concise article, we will guide you through the process of converting text to all caps in Google Sheets using the UPPER function.

A screenshot of Google Sheets demonstrating the use of the UPPER function, with the text "Whispering walrus" in cell B5 and the formula "=UPPER(B5)" in cell C5, resulting in the text "WHISPERING WALRUS" in all capital letters.

How to Make Capital Letters in Google Sheets


To convert text to all capital letters in Google Sheets and change the case of a cell, follow these simple steps:

  1. Enter the UPPER function in the cell where you want to change the text to all caps =UPPER(text)

  2. Add the text you want to convert to all caps =UPPER(B5)

  3. Press "enter" to complete


Complete formula:

=UPPER(B5)

By following these steps, you can quickly change text to all capital letters in Google Sheets with the UPPER function.


Check out this video tutorial here.

Comments


bottom of page