{"id":9941,"date":"2019-03-28T12:28:10","date_gmt":"2019-03-28T11:28:10","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=9941"},"modified":"2023-11-30T17:46:07","modified_gmt":"2023-11-30T16:46:07","slug":"upper-formula-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/upper-formula-in-excel\/","title":{"rendered":"UPPER Formula in Excel"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Converts all characters in the text into uppercase<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=UPPER(<span style=\"color: #0000ff;\">text<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=UPPER(<span style=\"color: #0000ff;\">text to be converted to upper case<\/span>)<\/p>\n<hr \/>\n<p>We can easily change text into upper case using the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/text\/upper\/\" target=\"_blank\" rel=\"noopener\">UPPER formula\u00a0in Excel<\/a>. It does not convert symbols and numbers though which we will see in the examples.<\/p>\n<p>If you want to fix the uneven capitalization throughout the text, then this formula is perfect for you!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/8GH96yurA_w?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">UPPER-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>UPPER\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h2 style=\"text-align: center;\"><span style=\"color: #0000ff;\">=UPPER(<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"UPPER Formula in Excel\"  class=\"aligncenter size-full wp-image-10040\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-01.jpg\" alt=\"UPPER Formula in Excel\" width=\"427\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-01.jpg 427w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-01-300x115.jpg 300w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>UPPER\u00a0<\/b>arguments:<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/upper-formula-in-excel\/#text\" title=\"text\">text<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"text\"><\/span><span style=\"color: #0000ff;\"><em><strong>text<\/strong><\/em><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>What is the text to be converted to upper case?<\/strong><\/p>\n<p><em>Select the cell containing the text that you want to convert:<\/em><\/p>\n<h2 style=\"text-align: center;\">=UPPER(<span style=\"color: #0000ff;\">C9)<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"UPPER Formula in Excel\"  class=\"aligncenter size-full wp-image-10041\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-02.jpg\" alt=\"UPPER Formula in Excel\" width=\"417\" height=\"162\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-02.jpg 417w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-02-300x117.jpg 300w\" sizes=\"(max-width: 417px) 100vw, 417px\" \/><\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"UPPER Formula in Excel\"  class=\"aligncenter size-full wp-image-10042\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-03.jpg\" alt=\"UPPER Formula in Excel\" width=\"427\" height=\"164\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-03.jpg 427w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-03-300x115.jpg 300w\" sizes=\"(max-width: 427px) 100vw, 427px\" \/><\/p>\n<p>You can see that the values are all now in upper case!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"UPPER Formula in Excel\"  class=\"aligncenter size-full wp-image-10043\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-04.jpg\" alt=\"UPPER Formula in Excel\" width=\"440\" height=\"191\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-04.jpg 440w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/UPPER-FORMULA-04-300x130.jpg 300w\" sizes=\"(max-width: 440px) 100vw, 440px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff;\"><strong>How to Use the UPPER Formula in Excel<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/ebooks.myexcelonline.com\/products\/101-most-popular-excel-formulas-e-book\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-10741\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book.png\" alt=\"\" width=\"1200\" height=\"628\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book.png 1200w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book-1024x536.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book-768x402.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; What does it do? Converts all characters in the text into uppercase Formula breakdown: =UPPER(text) What it means: =UPPER(text to be converted to upper case) We can easily change text into upper case using the UPPER formula\u00a0in Excel. It does not convert symbols and numbers though which we will see in the examples. If [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17744,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"UPPER Formula in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[487,3,14],"tags":[142,70,488],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9941"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=9941"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9941\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17744"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=9941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=9941"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=9941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}