{"id":668,"date":"2018-12-26T21:42:33","date_gmt":"2018-12-27T03:42:33","guid":{"rendered":"http:\/\/www.iqaccountingsolutions.com\/blog\/?p=668"},"modified":"2019-03-22T21:42:36","modified_gmt":"2019-03-23T02:42:36","slug":"change-the-case-of-text-in-excel","status":"publish","type":"post","link":"https:\/\/www.iqaccountingsolutions.com\/blog\/change-the-case-of-text-in-excel\/","title":{"rendered":"Change the Case of Text in Excel"},"content":{"rendered":"<p>If you copy text onto a spreadsheet it may not be capitalized the way you want. Or if several different people work on the same spreadsheet you may get some people typing in all caps while others use normal capitalization. Or maybe you just changed your mind.\u00a0 Excel doesn\u2019t have a <em>Change Case<\/em> button like Word does, but you don\u2019t have to copy your text to Word to change case and copy it back. Excel has three functions you can use:<\/p>\n<p><em>UPPER<\/em> displays text in all upper case<br \/>\n<em>LOWER<\/em> displays text in all lower case<br \/>\n<em>PROPER<\/em> displays text with the first letter of each word capitalized<\/p>\n<p>All three functions work the same way so I\u2019ll demonstrate with UPPER. For example, if you have text in cell A1 that you want to convert to upper case, go to any other cell and enter the formula <em>=UPPER(A1)<\/em>.The text from cell A1 will now display there in all upper case letters.<\/p>\n<p>The one obvious problem is that now you have the same text in two places. You can\u2019t just delete cell A1 or there won\u2019t be any text for the formula to convert to upper case. So here is how you can get just the text you want. If column A has the text that needs to be converted, insert a new column in column B. In cell B1 enter the formula <em>=UPPER(A1)<\/em> and copy it down to convert all of the text in column A. While you still have the cells in column B selected right-click on the selected cells and choose <em>Copy<\/em>. Right-click on the highlighted cells again and choose <em>Paste Special<\/em>, then <em>Values<\/em>. Now the formulas have been replaced with text so you can delete column A.<\/p>\n<p>For more details about using Paste Special see <a href=\"http:\/\/www.iqaccountingsolutions.com\/blog\/replacing-an-excel-formula-with-a-number\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.iqaccountingsolutions.com\/blog\/replacing-an-excel-formula-with-a-number\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Text copied or imported onto a spreadsheet may not be capitalized the way you want.  Or if several different people work on the same spreadsheet you may get some people typing in all caps while others use normal capitalization.  Excel doesn&#8217;t have a Change Case button like Word does, but you don&#8217;t have to copy your text to Word to change case and copy it back.  Excel has three functions, UPPER, LOWER, and PROPER that you can use to change the case of text.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/668"}],"collection":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=668"}],"version-history":[{"count":3,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/668\/revisions"}],"predecessor-version":[{"id":2396,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/668\/revisions\/2396"}],"wp:attachment":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}