{"id":344,"date":"2014-09-26T11:36:02","date_gmt":"2014-09-26T09:36:02","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=344"},"modified":"2023-11-30T01:31:25","modified_gmt":"2023-11-30T00:31:25","slug":"find-and-replace","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/find-and-replace\/","title":{"rendered":"Find &#038; Replace"},"content":{"rendered":"<p>The <em>Find &amp; Replace<\/em> feature or CTRL+H <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/333-excel-shortcuts-for-windows-and-mac\/\" target=\"_blank\" rel=\"noopener\" title=\"shortcut\" data-wpil-keyword-link=\"linked\">shortcut<\/a> allows you to amend your data in seconds.\u00a0 Imagine you had thousands of rows of data that was downloaded from an external system with the wrong date.\u00a0 A simple CTRL+H will save you heaps of time!\u00a0 See how below.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/Mq7ziDiq3gQ?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><\/p>\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=\"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><br \/>\n<span style=\"color: #0000ff;\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Find-Replace.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff;\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Find-Replace.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span>Let us try replacing the years 2015 with the year 2021. Select all of the <strong>Order Dates<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find &amp; Replace\"  class=\"alignnone size-full wp-image-19922\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-01.jpg\" alt=\"Find &amp; Replace\" width=\"764\" height=\"299\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-01.jpg 764w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-01-300x117.jpg 300w\" sizes=\"(max-width: 764px) 100vw, 764px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong> <\/span>Go to\u00a0\u00a0<em><strong>Home &gt; Find &amp; Select &gt; Replace<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find &amp; Replace\"  class=\"alignnone size-full wp-image-19923\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-02.jpg\" alt=\"Find &amp; Replace\" width=\"1369\" height=\"417\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-02.jpg 1369w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-02-300x91.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-02-1024x312.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-02-768x234.jpg 768w\" sizes=\"(max-width: 1369px) 100vw, 1369px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong> <\/span>We want to replace 2015 with 2021. Type that in, then click <strong>Replace All<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find &amp; Replace\"  class=\"alignnone size-full wp-image-19924\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-03.jpg\" alt=\"Find &amp; Replace\" width=\"443\" height=\"194\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-03.jpg 443w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-03-300x131.jpg 300w\" sizes=\"(max-width: 443px) 100vw, 443px\" \/><\/p>\n<p>Click <strong>OK<\/strong>. Your values are now replaced<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find &amp; Replace\"  class=\"alignnone size-full wp-image-19925\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-04.jpg\" alt=\"Find &amp; Replace\" width=\"954\" height=\"289\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-04.jpg 954w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-04-300x91.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-04-768x233.jpg 768w\" sizes=\"(max-width: 954px) 100vw, 954px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong> <\/span>You can also use it to remove values. Let us say we want to remove the <strong>NORTH Region<\/strong><\/p>\n<p>Select the values of the <strong>REGION Column<\/strong>. Go to\u00a0 <em><strong>Home &gt; Find &amp; Select &gt; Replace<\/strong><\/em><\/p>\n<p>Type in the values to find the\u00a0<strong>NORTH<\/strong> text and replace it with a blank. Click\u00a0<strong>Replace All<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find &amp; Replace\"  class=\"alignnone size-full wp-image-19926\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-05.jpg\" alt=\"Find &amp; Replace\" width=\"854\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-05.jpg 854w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-05-300x105.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-05-768x270.jpg 768w\" sizes=\"(max-width: 854px) 100vw, 854px\" \/><\/p>\n<p>The\u00a0<strong>NORTH\u00a0<\/strong>values are now removed!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Find &amp; Replace\"  class=\"alignnone size-full wp-image-19927\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-06.jpg\" alt=\"Find &amp; Replace\" width=\"877\" height=\"355\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-06.jpg 877w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-06-300x121.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/find-and-replace-06-768x311.jpg 768w\" sizes=\"(max-width: 877px) 100vw, 877px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Find &amp; Replace feature or CTRL+H shortcut allows you to amend your data in seconds.\u00a0 Imagine you had thousands of rows of data that was downloaded from an external system with the wrong date.\u00a0 A simple CTRL+H will save you heaps of time!\u00a0 See how below. \ufeff download workbookFind-Replace.xlsx &nbsp; STEP 1: Let us [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17758,"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,52],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/344"}],"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=344"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/344\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17758"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}