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.
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:
Enter the UPPER function in the cell where you want to change the text to all caps =UPPER(text)
Add the text you want to convert to all caps =UPPER(B5)
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