{"id":9923,"date":"2019-07-30T16:30:18","date_gmt":"2019-07-30T14:30:18","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=9923"},"modified":"2024-03-22T21:08:05","modified_gmt":"2024-03-22T20:08:05","slug":"lower-formula-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/lower-formula-in-excel\/","title":{"rendered":"LOWER 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 lowercase<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=LOWER(<span style=\"color: #0000ff\">text<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=LOWER(<span style=\"color: #0000ff\">text to be converted to lower case<\/span>)<\/p>\n<hr \/>\n<p>We can easily change text into lower case using the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/text\/lower\/\" target=\"_blank\" rel=\"noopener\">LOWER\u00a0formula\u00a0in<\/a> Excel. It does not convert symbols and numbers though which we will see in the examples.<\/p>\n<p>If you want to get rid of 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\/m67bEVb4bB8?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"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\/LOWER-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-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\">LOWER-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>LOWER\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h2 style=\"text-align: center\"><span style=\"color: #0000ff\">=LOWER(<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"LOWER Formula in Excel\" class=\"aligncenter size-full wp-image-9928\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-01.jpg\" alt=\"LOWER Formula in Excel\" width=\"419\" height=\"154\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-01.jpg 419w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-01-300x110.jpg 300w\" sizes=\"(max-width: 419px) 100vw, 419px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>LOWER\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\/lower-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 lower 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\">=LOWER(<span style=\"color: #0000ff\">C9)<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"LOWER Formula in Excel\" class=\"aligncenter size-full wp-image-9932\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-02-1.jpg\" alt=\"LOWER Formula in Excel\" width=\"418\" height=\"153\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-02-1.jpg 418w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-02-1-300x110.jpg 300w\" sizes=\"(max-width: 418px) 100vw, 418px\" \/><\/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=\"LOWER Formula in Excel\" class=\"aligncenter size-full wp-image-9933\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-03-1.jpg\" alt=\"LOWER Formula in Excel\" width=\"428\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-03-1.jpg 428w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-03-1-300x114.jpg 300w\" sizes=\"(max-width: 428px) 100vw, 428px\" \/><\/p>\n<p>You can see that the values are <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/change-font-to-all-caps\/\" target=\"_blank\" rel=\"noopener\">all now in lower case<\/a>!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"LOWER Formula in Excel\" class=\"aligncenter size-full wp-image-9931\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-04.jpg\" alt=\"LOWER Formula in Excel\" width=\"445\" height=\"191\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-04.jpg 445w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/LOWER-FORMULA-04-300x129.jpg 300w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff\"><strong>How to Use the LOWER 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\" title=\"SORT Formula in Excel\" 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=\"SORT Formula in Excel\" 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\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; What does it do? Converts all characters in the text into lowercase Formula breakdown: =LOWER(text) What it means: =LOWER(text to be converted to lower case) We can easily change text into lower case using the LOWER\u00a0formula\u00a0in Excel. It does not convert symbols and numbers though which we will see in the examples. If you [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17992,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"LOWER Formula in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[481,3,14],"tags":[142,482],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9923"}],"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=9923"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/9923\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17992"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=9923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=9923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=9923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}