{"id":1401,"date":"2015-06-18T18:53:09","date_gmt":"2015-06-18T16:53:09","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=1401"},"modified":"2023-11-30T01:38:13","modified_gmt":"2023-11-30T00:38:13","slug":"find-errors-with-go-to-special-constants-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/find-errors-with-go-to-special-constants-excel\/","title":{"rendered":"Find Errors with Go to Special Constants"},"content":{"rendered":"<p>&nbsp;<\/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\/find-errors-with-go-to-special-constants-excel\/#Want_to_know_How_to_Locate_Errors_in_an_Excel_Formula\" title=\"Want to know How to Locate Errors in an Excel Formula?\">Want to know How to Locate Errors in an Excel Formula?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Want_to_know_How_to_Locate_Errors_in_an_Excel_Formula\"><\/span><em><strong>Want to know How to Locate Errors in an Excel Formula?<\/strong><\/em><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/KQtPZMgJxTQ?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\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span>?<\/span><\/iframe><\/p>\n<div>\n<div style=\"float: left;\"><span style=\"text-decoration: underline;\"><strong><a href=\"https:\/\/youtu.be\/KQtPZMgJxTQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Watch on YouTube<\/a> <\/strong><\/span>and give it a thumbs up &#x1f44d;<\/div>\n<div>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright 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>Say you have a data set and want to make sure that each column contains what it is supposed to.<\/p>\n<p>For example, say you have a column which contains <em>Dates<\/em> and you want to check that there are no cells which contain T<em>ext<\/em>.<\/p>\n<p>You can easily check this by highlighting that column and pressing<strong> CTRL+G<\/strong> to bring up the <strong>Go To<\/strong> dialogue box (or by choosing from the menu <em>Home &gt; Find &amp; Select &gt; Go To&#8230;<\/em>)<\/p>\n<p>Then you need to choose <em>Special &gt; Constants<\/em> and select the constant that you want to find in your column.<\/p>\n<p>In our example you will need to only select the <em>Text<\/em> box and de-select the other boxes and press OK.\u00a0 This will highlight the cells that contain text and you can begin to format these cells.<\/p>\n<p>See how this is done by watching the gif tutorial below.<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><a class=\"IRPP_minimalist icon-download\" style=\"color: #0000ff;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Go-To-Constants.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\">Download workbook<\/span><span class=\"postTitle px-3\">Go-To-Constants.xlsx<\/span><\/a><\/span><\/p>\n<\/div>\n<p>This is our source table, we want to get the order dates that are in the text format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Errors with Go to Special Constants\"  class=\"alignnone size-full wp-image-19629\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-01.jpg\" alt=\"Find Errors with Go to Special Constants\" width=\"707\" height=\"387\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-01.jpg 707w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-01-300x164.jpg 300w\" sizes=\"(max-width: 707px) 100vw, 707px\" \/><\/p>\n<div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1: <\/strong><\/span>Select the <strong>Order Date<\/strong> column values.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Errors with Go to Special Constants\"  class=\"alignnone size-full wp-image-19630\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-02.jpg\" alt=\"Find Errors with Go to Special Constants\" width=\"714\" height=\"397\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-02.jpg 714w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-02-300x167.jpg 300w\" sizes=\"(max-width: 714px) 100vw, 714px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2: <\/strong><\/span>Press\u00a0<strong>CTRL + G\u00a0<\/strong>to open the\u00a0<strong>Go To\u00a0<\/strong>dialog. Select\u00a0<strong>Special.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Errors with Go to Special Constants\"  class=\"alignnone size-full wp-image-19631\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-03.jpg\" alt=\"Find Errors with Go to Special Constants\" width=\"283\" height=\"269\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3: <\/strong><\/span>We want to select the text values in the <strong>Order Date<\/strong> column.<\/p>\n<p>To do that, select\u00a0<strong>Constants<\/strong> and ensure that only\u00a0<strong>Text\u00a0<\/strong>is ticked. Because our invalid values are in the text format.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Errors with Go to Special Constants\"  class=\"alignnone size-full wp-image-19632\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-04.jpg\" alt=\"Find Errors with Go to Special Constants\" width=\"314\" height=\"330\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-04.jpg 314w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-04-285x300.jpg 285w\" sizes=\"(max-width: 314px) 100vw, 314px\" \/><\/p>\n<p>Now Excel has highlighted the text values for you and you can make the necessary changes!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find Errors with Go to Special Constants\"  class=\"alignnone size-full wp-image-19633\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-05.jpg\" alt=\"Find Errors with Go to Special Constants\" width=\"728\" height=\"398\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-05.jpg 728w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/Find-Errors-with-Go-to-Special-Constants-05-300x164.jpg 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/p>\n<p><span style=\"text-decoration: underline;\"><span style=\"color: #0000ff; text-decoration: underline;\">HELPFUL RESOURCE:<\/span><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-722 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/728x901-e1413496235820.gif\" alt=\"728x90\" width=\"599\" height=\"74\" title=\"\"><\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Want to know How to Locate Errors in an Excel Formula? *** Watch our video and step by step guide below with free downloadable Excel workbook to practice *** \ufeff? Watch on YouTube and give it a thumbs up &#x1f44d; Say you have a data set and want to make sure that each column [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":16180,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,37],"tags":[88,53],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1401"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=1401"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/1401\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/16180"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=1401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=1401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=1401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}