{"id":4588,"date":"2023-02-21T16:45:44","date_gmt":"2023-02-21T16:45:44","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=4588"},"modified":"2024-03-14T15:42:50","modified_gmt":"2024-03-14T15:42:50","slug":"how-to-use-find-and-replace-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-use-find-and-replace-in-excel\/","title":{"rendered":"How to use Find and Replace in Excel?"},"content":{"rendered":"<p>Find and Replace in Excel is an invaluable tool for anyone looking to streamline their data management processes. Whether it&#8217;s updating information, correcting errors, standardizing data, or ensuring confidentiality, this feature simplifies and accelerates the task of modifying large datasets. By mastering Find and Replace, you can enhance productivity, maintain data integrity, and ensure consistency across your Excel projects. Incorporate this powerful function into your workflow to transform the way you handle and analyze data, making your Excel experience more efficient and error-free.<\/p>\n<p><strong>This Content Covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#how-to-use-find-in-excel?\"><strong> How to use Find in Excel?<\/strong><\/a>\n<ul>\n<li><strong>Find a Value in a Range, Spreadsheet, or Workbook<\/strong><\/li>\n<li><strong>In Excel, Look for Cells with a Particular Format<\/strong><\/li>\n<li><strong>How to Select and Highlight all Found Entries on a Sheet<\/strong><\/li>\n<li><strong>Find Cells with Formulas in Excel<\/strong><\/li>\n<li><strong>Additional options for Excel Find<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-use-replace-in-excel?\"><strong> How to use Replace in Excel?<\/strong><\/a>\n<ul>\n<li><strong>Replace One Value with Another<\/strong><\/li>\n<li><strong>Method for Finding or Replacing Line Breaks<\/strong><\/li>\n<li><strong>How to Change Cell Formatting on the Sheet<\/strong><\/li>\n<li><strong>How to Replace Wildcard Characters in Excel Using the Find and Replace Function<\/strong><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#shortcuts-for-find-and-replace-in-excel\"><strong> Shortcuts for Find and Replace in Excel<\/strong><\/a><\/li>\n<\/ol>\n<h2><strong id=\"how-to-use-find-in-excel?\">1. How to use Find in Excel?<\/strong><\/h2>\n<p><strong>1.1 Find a Value in a <a href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-find-range-in-excel\/\" target=\"_blank\" rel=\"noopener\">Range<\/a>, Spreadsheet, or Workbook<\/strong><\/p>\n<p>You can use the following instructions to locate particular characters, text, numbers, or dates in a group of cells, a worksheet, or the whole workbook.<\/p>\n<p><strong>Step 1: <\/strong>Select the range of cells from which you want to look for the value and go to <strong>Home&gt;&gt;Find &amp; Select&gt;&gt;Find.<\/strong> Or you can select the range and press <strong>CTRL+F<\/strong> keys to open <strong>Find and Replace<\/strong> dialogue box.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-4589 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-1.png\" alt=\"Find and Replace in Excel\" width=\"640\" height=\"256\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-1.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-1-300x120.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Go to <strong>Find <\/strong>tab and input the name or value or text you are looking for inside <strong>Find What<\/strong> box. If you want to look only withing your current worksheet then select <strong>Sheet <\/strong>from <strong>Within <\/strong>box. Choose <strong>Workbook<\/strong> if you want to search the entire workbook.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-4590 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-2.png\" alt=\"Find and Replace in Excel\" width=\"635\" height=\"347\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-2.png 635w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-2-300x164.png 300w\" sizes=\"(max-width: 635px) 100vw, 635px\" \/><\/p>\n<p><strong>Step 3:<\/strong> If you click on <strong>Find Next<\/strong>, it will show the value\u2019s first occurrence. The second click selects the second occurrence, and so on.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-4591 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-3.png\" alt=\"Find and Replace in Excel\" width=\"642\" height=\"207\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-3.png 642w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-3-300x97.png 300w\" sizes=\"(max-width: 642px) 100vw, 642px\" \/><\/p>\n<p><strong>Step 4: <\/strong>Excel displays a list of all occurrences when you click <strong>Find All.<\/strong> Any item in the list can be clicked to get to the relevant cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4592 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-4.png\" alt=\"Find and Replace in Excel\" width=\"546\" height=\"417\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-4.png 546w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-4-300x229.png 300w\" sizes=\"(max-width: 546px) 100vw, 546px\" \/><\/p>\n<p><span style=\"color: #0000ff;\"><strong>Also Read:<span style=\"text-decoration: underline;\"><span style=\"color: #3366ff; text-decoration: underline;\">\u00a0<\/span><\/span><\/strong><span style=\"text-decoration: underline;\"><span style=\"color: #3366ff; text-decoration: underline;\"><a style=\"color: #3366ff; text-decoration: underline;\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-wrap-text-in-excel-including-shortcuts\/\" target=\"_blank\" rel=\"noopener\"><em>How to Wrap Text in Excel (including shortcuts)<\/em><\/a><\/span><\/span><\/span><\/p>\n<p><strong>1.2 In Excel, Look for Cells with a Particular Format<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Press <strong>CTRL+F<\/strong> key to open Find and Replace dialogue box. Click on the <a href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-create-a-drop-down-list-in-excel\/\" target=\"_blank\" rel=\"noopener\">drop-down<\/a> button of <strong>Format<\/strong> box and select <strong>Choose Format From Cell. <\/strong>You can also choose from <strong>Find Format<\/strong> dialogue box by clicking <strong>Format.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4593\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-5.png\" alt=\"FIND and REPLACE\" width=\"613\" height=\"275\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-5.png 613w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-5-300x135.png 300w\" sizes=\"(max-width: 613px) 100vw, 613px\" \/><\/p>\n<p><strong>Step 2: <\/strong>When you select <strong>Choose Format From Cell, <\/strong>a plus icon with a dropper icon will appear. Select the cell from which you want to choose the format from.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4594\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-6.png\" alt=\"FIND and REPLACE\" width=\"617\" height=\"194\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-6.png 617w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-6-300x94.png 300w\" sizes=\"(max-width: 617px) 100vw, 617px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Press <strong>Find Next<\/strong> or <strong>Find All<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4595\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-7.png\" alt=\"FIND and REPLACE\" width=\"416\" height=\"318\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-7.png 416w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-7-300x229.png 300w\" sizes=\"(max-width: 416px) 100vw, 416px\" \/><\/p>\n<p><strong>1.3 How to Select and Highlight all Found Entries on a Sheet<\/strong><\/p>\n<p><strong>Step 1: <\/strong>To select the list of entries inside <strong>Find and Replace<\/strong> dialogue box, click on any of the entries and then press <strong>CTRL+A<\/strong> to select all of them at once.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4596\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-8.png\" alt=\"FIND and REPLACE\" width=\"642\" height=\"276\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-8.png 642w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-8-300x129.png 300w\" sizes=\"(max-width: 642px) 100vw, 642px\" \/><\/p>\n<p><strong>Step 2: <\/strong>The cells in your selected range are also selected now, simply change the cell color from ribbon to highlight them.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4597\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-9.png\" alt=\"FIND and REPLACE\" width=\"640\" height=\"410\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-9.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-9-300x192.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>1.4 Find Cells with Formulas in Excel<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Select the range of cells then go to <strong>Home&gt;&gt;Find &amp; Select&gt;&gt;Go to Special.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4598\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-10.png\" alt=\"FIND and REPLACE\" width=\"261\" height=\"370\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-10.png 261w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-10-212x300.png 212w\" sizes=\"(max-width: 261px) 100vw, 261px\" \/><\/p>\n<p><strong>Step 2: <\/strong>From <strong>Go to Special <\/strong>dialogue box and select <strong>Formulas.<\/strong> Make sure all the boxes from Formulas option are checked and click <strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4599\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-11.png\" alt=\"FIND and REPLACE \" width=\"342\" height=\"357\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-11.png 342w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-11-287x300.png 287w\" sizes=\"(max-width: 342px) 100vw, 342px\" \/><\/p>\n<p><strong>Step 3:<\/strong> All the cells that contain formulas will be highlighted in your selected range.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-4600 size-full\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-12.png\" alt=\"Find and Replace in Excel\" width=\"637\" height=\"220\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-12.png 637w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-12-300x104.png 300w\" sizes=\"(max-width: 637px) 100vw, 637px\" \/><\/p>\n<p><strong>1.5 Additional options for Excel Find<\/strong><\/p>\n<p><strong>The find and Replace<\/strong> dialogue box provides us with some additional options for a better and more accurate search result. To view the additional options, click on the <strong>Options <\/strong>button in the dialogue box.<\/p>\n<ul>\n<li>The <strong>Within<\/strong> box has two options, <strong>Sheet <\/strong>and <strong>Workbook<\/strong>. So, we can search for a value from only the worksheet or the entire workbook according to our preferences.<\/li>\n<li>Select <strong>By Rows<\/strong> in the <strong>Search <\/strong>box to search the current cell from left to right, row by row. Select <strong>By Columns<\/strong> to do a column-by-column search from top-to-bottom.<\/li>\n<li>Select <strong>Formulas<\/strong>, <strong>Values<\/strong>, or <strong>Comments <\/strong>in the <strong>Look-in<\/strong> box to search among a certain data type.<\/li>\n<li>Check the <strong>Match case<\/strong> check box for a case-sensitive search.<\/li>\n<\/ul>\n<p>Select <strong>the Match complete cell contents<\/strong> option to look for cells that only contain the characters you specified in the Find what box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4601\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-13.png\" alt=\"FIND and REPLACE\" width=\"543\" height=\"301\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-13.png 543w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-13-300x166.png 300w\" sizes=\"(max-width: 543px) 100vw, 543px\" \/><\/p>\n<h2><strong id=\"how-to-use-replace-in-excel?\">2. How to use Replace in Excel?<\/strong><\/h2>\n<p><strong>2.1 Replace One Value with Another<\/strong><\/p>\n<p><strong>Step 1:<\/strong> Select the range and go to <strong>Home&gt;&gt;Find &amp; Select&gt;&gt;Replace.<\/strong> Or press <strong>CTRL+H<\/strong> keys to open <strong>Replace<\/strong> tab in <strong>Find and Replace<\/strong> dialogue box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4602\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-14.png\" alt=\"FIND and REPLACE\" width=\"292\" height=\"413\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-14.png 292w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-14-212x300.png 212w\" sizes=\"(max-width: 292px) 100vw, 292px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Input the value to search for in the <strong>Find what<\/strong> box, and then type the value to replace it with in the <strong>Replace with<\/strong> box. Select <strong>Replace<\/strong> to swap out each of the detected entries individually or <strong>Replace All<\/strong> to switch out every entry at once.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4603\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-15.png\" alt=\"FIND and REPLACE\" width=\"586\" height=\"324\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-15.png 586w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-15-300x166.png 300w\" sizes=\"(max-width: 586px) 100vw, 586px\" \/><\/p>\n<p><strong>2.2 Method for Finding or Replacing\u00a0Line Breaks<\/strong><\/p>\n<p>You can replace a\u00a0line break\u00a0with a space or any other separator by following the steps below.<\/p>\n<p><strong>Step 1: <\/strong>To find and replace <a href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-remove-line-breaks-carriage-return-in-excel\/\" target=\"_blank\" rel=\"noopener\">line breaks<\/a> in a range, select the range and press <strong>CTRL+H<\/strong> to open <strong>Replace<\/strong> tab in <strong>Find and Replace<\/strong> dialogue box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4604\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-16.png\" alt=\"FIND and REPLACE\" width=\"578\" height=\"318\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-16.png 578w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-16-300x165.png 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Select the <strong>Find What<\/strong> box and press <strong>CTRL+J.<\/strong> This shortcut is a controlled code for line breaks. The Find What box may first appear empty, but upon looking closer, you&#8217;ll see a little flickering dot, as shown in the picture below. Enter a space as a replacing character inside <strong>Replace with<\/strong> box and click\u00a0<strong>Replace All.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4605\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-17.png\" alt=\"FIND and REPLACE\" width=\"569\" height=\"315\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-17.png 569w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-17-300x166.png 300w\" sizes=\"(max-width: 569px) 100vw, 569px\" \/><\/p>\n<p><span style=\"color: #0000ff;\"><strong>Also Read:<span style=\"text-decoration: underline;\"><span style=\"color: #3366ff; text-decoration: underline;\">\u00a0<\/span><\/span><\/strong><span style=\"text-decoration: underline;\"><span style=\"color: #3366ff; text-decoration: underline;\"><a style=\"color: #3366ff; text-decoration: underline;\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-capitalize-first-letter-in-excel\/\" target=\"_blank\" rel=\"noopener\"><em>How to Capitalize First Letter in Excel?<\/em><\/a><\/span><\/span><\/span><\/p>\n<p><strong>2.3 How to Change Cell Formatting on the Sheet<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Press <strong>CTRL+H<\/strong> keys to open <strong>Find and Replace<\/strong> dialogue box. Click the Format button&#8217;s arrow next to the Find what box, select <strong>Choose Format From Cell<\/strong> and then click any cell that has the format you want to change.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4606\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-18.png\" alt=\"FIND and REPLACE\" width=\"659\" height=\"200\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-18.png 659w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-18-300x91.png 300w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Click the <strong>Format<\/strong> button next to <strong>Replace With<\/strong> box and select <strong>Choose Format From Cell.<\/strong> Then click on any cell from column A or column C which are formatted as <strong>General.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4607\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-19.png\" alt=\"FIND and REPLACE\" width=\"629\" height=\"292\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-19.png 629w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-19-300x139.png 300w\" sizes=\"(max-width: 629px) 100vw, 629px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Click <strong>Replace All<\/strong> and all the cells from column B which were formatted as <strong>Date<\/strong> will be formatted as <strong>General<\/strong> now and instead of the dates, those cells will show only the serial numbers for those dates.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4608\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-20.png\" alt=\"FIND and REPLACE\" width=\"639\" height=\"240\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-20.png 639w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-20-300x113.png 300w\" sizes=\"(max-width: 639px) 100vw, 639px\" \/><\/p>\n<p><strong>2.4 How to Replace Wildcard Characters in Excel Using the Find and Replace Function<\/strong><\/p>\n<p><strong>Step 1: <\/strong>Here we have a wildcard character <strong>(?) <\/strong>in cell C1. To replace it, first press <strong>CTRL+H<\/strong> to open <strong>Find and Replace<\/strong> dialogue box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4609\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-21.png\" alt=\"FIND and REPLACE\" width=\"640\" height=\"283\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-21.png 640w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-21-300x133.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Type the tilde character <strong>(~) <\/strong>before the question<strong> (?)<\/strong> mark in <strong>Find What<\/strong> box and type the value u want it to replace with inside <strong>Replace With<\/strong> box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4610\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-22.png\" alt=\"FIND and REPLACE \" width=\"625\" height=\"345\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-22.png 625w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-22-300x166.png 300w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p><strong>Step 3: <\/strong>Press <strong>Replace All<\/strong> and the wildcard character will be replaced.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4611\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-23.png\" alt=\"FIND and REPLACE\" width=\"651\" height=\"236\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-23.png 651w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/02\/FIND-and-REPLACE-23-300x109.png 300w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/p>\n<h2><strong id=\"shortcuts-for-find-and-replace-in-excel\">3. Shortcuts for Find and Replace in Excel<\/strong><\/h2>\n<p>There are few useful shortcuts you can use while operating with Find and Replace in Excel.<\/p>\n<ul>\n<li><strong>CTRL+F<\/strong>\u2013 To open the\u00a0<strong>Find<\/strong>\u00a0tab in <strong>Find and Replace<\/strong> dialogue box.<\/li>\n<li><strong>CTRL+H<\/strong>&#8211; To open the\u00a0<strong>Replace<\/strong>\u00a0tab in <strong>Find and Replace<\/strong> dialogue box.<\/li>\n<li><strong>CTRL+J<\/strong>\u2013 To Find or Replace a line break.<\/li>\n<li><strong>CTRL+SHIFT+F4<\/strong>\u2013 To locate an earlier occurrence of the search value.<\/li>\n<\/ul>\n<p><strong>SHIFT+F4<\/strong>\u00a0\u2013 To find the next occurrence of the search value.<\/p>\n<h2><strong>Application of Find and Replace in Excel<\/strong><\/h2>\n<ul>\n<li><strong>Updating Information<\/strong>: Use Find and Replace to quickly update specific information, such as changing a company name or address across multiple cells or sheets.<\/li>\n<li><strong>Correcting Spelling Errors<\/strong>: Correct common spelling mistakes throughout a spreadsheet by finding the incorrect spelling and replacing it with the correct one.<\/li>\n<li><strong>Standardizing Data Formats<\/strong>: Standardize formats for data entries, like dates or phone numbers, by replacing various formats with a uniform one across the dataset.<\/li>\n<li><strong>Removing Unwanted Characters<\/strong>: Find and eliminate unwanted or non-printable characters that may have been introduced during data import or copying from other sources.<\/li>\n<li><strong>Batch Updating Formulas<\/strong>: Update parts of formulas, such as cell references or function names, across multiple cells at once, ensuring consistency and saving time.<\/li>\n<li><strong>Data Anonymization<\/strong>: Replace personal or sensitive information with anonymous identifiers to protect privacy or for publishing data while maintaining confidentiality.<\/li>\n<\/ul>\n<p>For ready-to-use Dashboard Templates:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Find and Replace in Excel is an invaluable tool for anyone looking to streamline their data management processes. Whether it&#8217;s updating information, correcting errors, standardizing data, or ensuring confidentiality, this feature simplifies and accelerates the task of modifying large datasets. By mastering Find and Replace, you can enhance productivity, maintain data integrity, and ensure consistency &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-use-find-and-replace-in-excel\/\"> <span class=\"screen-reader-text\">How to use Find and Replace in Excel?<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[544],"tags":[546,545],"class_list":["post-4588","post","type-post","status-publish","format-standard","hentry","category-find-and-replace-in-excel","tag-find-and-replace","tag-find-and-replace-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/4588","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=4588"}],"version-history":[{"count":7,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/4588\/revisions"}],"predecessor-version":[{"id":8850,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/4588\/revisions\/8850"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=4588"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=4588"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=4588"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}