Syntax<\/h3>\n
UPPER(text)<\/strong><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We may have observed this is probably the simplest of syntaxes any Google Sheets formula can have. Although it is very straightforward as to what it does, let us look at a few examples to ensure we understand its behavior. Consider the snapshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/UPPER-formula-Illustration-Frame-1.png” alt=”UPPER Formula in Google Sheets” title_text=”upper-formula” align=”center” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In the first example, the formula converted the instances of lowercase letters, other than G and R, are into uppercase letters. Here the input is a direct text string, enclosed within a pair of double quotes. It may not always be feasible to manually type in the input strings. So, to save us from that effort, the LOWER formula also accepts references to cells that host these text values. Which is why we used cell references in the next three examples.<\/p>\n Regardless of the position of a lowercase character within the string, the formula converts every such instance to an uppercase character. It could be that all of the text is in lowercase (example 2), or in uppercase. Or it could also be that the characters in the input string are randomly lowercase and uppercase (example 3). It doesn\u2019t matter how many lowercase characters there are within the input string. The result the formula always generates an output in which every alphabet is in uppercase. That is true even in the case of alphanumeric strings (example 4).<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Numbers are what comes to our mind when we think of spreadsheets applications. That is no surprise because they simplify a lot of calculations for us. Thankfully, their\u00a0support is beyond just the numbers.\u00a0We also have solid help in the form of many text-based\u00a0formulas. Using them, we can manipulate the strings in many ways depending on […]<\/p>\n","protected":false},"author":40,"featured_media":9196,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Numbers are what comes to our mind when we think of spreadsheets applications. That is no surprise because they simplify a lot of calculations for us. Thankfully, their support is beyond just the numbers. We also have solid help in the form of many text-based formulas. Using them, we can manipulate the strings in many ways depending on our requirements. The UPPER<\/a> formula in Google Sheets is one such formula. It helps us to convert the text from lowercase to uppercase.\n\n
Usage: UPPER formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nUPPER(text)<\/strong>\n
\n \t
Usage: UPPER formula in Google Sheets<\/h3>\nWe may have observed this is probably the simplest of syntaxes any Google Sheets formula can have. Although it is very straightforward as to what it does, let us look at a few examples to ensure we understand its behavior. Consider the snapshot below.\n\n
![\"UPPER](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/UPPER-formula-Illustration-Frame-1.png\")
\n\nIn the first example, the formula converted the instances of lowercase letters, other than G and R, are into uppercase letters. Here the input is a direct text string, enclosed within a pair of double quotes. It may not always be feasible to manually type in the input strings. So, to save us from that effort, the LOWER formula also accepts references to cells that host these text values. Which is why we used cell references in the next three examples.\n\nRegardless of the position of a lowercase character within the string, the formula converts every such instance to an uppercase character. It could be that all of the text is in lowercase (example 2), or in uppercase. Or it could also be that the characters in the input string are randomly lowercase and uppercase (example 3). It doesn\u2019t matter how many lowercase characters there are within the input string. The result the formula always generates an output in which every alphabet is in uppercase. That is true even in the case of alphanumeric strings (example 4).","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-9195","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/9195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=9195"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/9195\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/9196"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=9195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=9195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=9195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}