UPPER Function

Converts lowercase characters in a text string to uppercase.
Sample Usage
UPPER("hello world!")
Syntax
UPPER(
  • text
)
  • text
    The string to convert to uppercase.
Examples

This example references the following sheet information:

  Clothing Item Transaction Total Units Sold In Stock?
1 T-Shirt 1,170.00 78 true
2 Pants 1,491.00 42 false
3 Jacket 812.00 217 true

Given the table above, here are some examples of using UPPER in a sheet:

Formula Description Result
=UPPER([Clothing Item]1) Converts lowercase characters in the “Clothing Item” column on row 1 to uppercase. T-SHIRT
=UPPER("welcome to Smartsheet") Converts lowercase characters in the text string “"welcome to Smartsheet" to uppercase. WELCOME TO SMARTSHEET
=IF([In Stock?]3 = false, UPPER([Clothing Item]3), [Clothing Item]3) Converts lowercase characters in the “Clothing Item” column on row 1 to uppercase if the value in the “In Stock” column on row 3 is equal to false. Returns the original string otherwise. Jacket