{"id":1265,"date":"2012-11-15T14:49:49","date_gmt":"2012-11-15T14:49:49","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=1265"},"modified":"2023-12-30T23:11:05","modified_gmt":"2023-12-30T23:11:05","slug":"how-to-correct-names-in-lower-case-in-excel-proper-case","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/how-to-correct-names-in-lower-case-in-excel-proper-case\/","title":{"rendered":"How to correct names in lower case in Excel (Proper Case)"},"content":{"rendered":"<p>It can be a pain when you have a list of names that are all in lower case, and you want to be able to change them to the right case. \u00a0This can be easily completed using a formula to make the changes.<\/p>\n<p><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/names-lowercase-excel-vba-courses-london.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-1267\" alt=\"names-lowercase-excel-vba-courses-london\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/names-lowercase-excel-vba-courses-london.png\" width=\"146\" height=\"181\" \/><\/a><\/p>\n<p><strong>To change this list of names to the proper case<\/strong>, I can use one of Excel&#8217;s off-the-peg <strong>Text formulas\u00a0<\/strong>by using <strong>PROPER.<\/strong><\/p>\n<figure id=\"attachment_1268\" aria-describedby=\"caption-attachment-1268\" style=\"width: 202px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/proper-formula-excel-vba-courses-london.png\"><img decoding=\"async\" class=\"size-full wp-image-1268\" alt=\"proper-formula-excel-vba-courses-london\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/proper-formula-excel-vba-courses-london.png\" width=\"202\" height=\"251\" \/><\/a><figcaption id=\"caption-attachment-1268\" class=\"wp-caption-text\">The Proper formula in the Formulas tab.<\/figcaption><\/figure>\n<p>To apply this, I need to use an empty column (in this case B) to apply the formula to the original names. \u00a0This is only temporary as I will copy the names back into Column A when it&#8217;s all done.<\/p>\n<p>I click on cell B2 to set up my formula. \u00a0I go to the <strong>Formulas tab<\/strong>, and select <strong>Text Formulas<\/strong>, and <strong>PROPER<\/strong>.<\/p>\n<p>A dialogue box appears, and I can now select the first name in column A.<\/p>\n<figure id=\"attachment_1270\" aria-describedby=\"caption-attachment-1270\" style=\"width: 300px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/active-cell-excel-vba-courses-london.png\"><img decoding=\"async\" class=\"size-medium wp-image-1270\" alt=\"active-cell-excel-vba-courses-london\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/active-cell-excel-vba-courses-london-300x97.png\" width=\"300\" height=\"97\" \/><\/a><figcaption id=\"caption-attachment-1270\" class=\"wp-caption-text\">selecting the cell contents that need to be changed<\/figcaption><\/figure>\n<p>When I click ok, the first name is now in the correct case. \u00a0I can copy this formula by using the autofill handle, to complete the changes to the remaining names.<\/p>\n<figure id=\"attachment_1271\" aria-describedby=\"caption-attachment-1271\" style=\"width: 116px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/Autofill-formula-excel-vba-courses-london.png\"><img decoding=\"async\" class=\"size-full wp-image-1271\" alt=\"Autofill-formula-excel-vba-courses-london\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/11\/Autofill-formula-excel-vba-courses-london.png\" width=\"116\" height=\"131\" \/><\/a><figcaption id=\"caption-attachment-1271\" class=\"wp-caption-text\">Autofilling the formula to the remaining cells<\/figcaption><\/figure>\n<p>The names have all be corrected and I can copy them from column B back into column A.<\/p>\n<p>Our Excel courses cover all levels from introduction to advanced, including Excel VBA courses london, <a title=\"Excel VBA courses London\" href=\"https:\/\/www.stl-training.co.uk\/vba-training-london.php\">https:\/\/www.stl-training.co.uk\/vba-training-london.php<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It can be a pain when you have a list of names that are all in lower case, and you want to be able to change them to the right case. \u00a0This can be easily completed using a formula to make the changes. To change this list of names to the proper case, I can [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[234],"class_list":["post-1265","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-vba-courses-london"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1265"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1265\/revisions"}],"predecessor-version":[{"id":6701,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1265\/revisions\/6701"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}