{"id":104864,"date":"2025-05-12T15:54:18","date_gmt":"2025-05-12T15:54:18","guid":{"rendered":"https:\/\/goodwriterz.com\/site\/?p=104864"},"modified":"2025-05-12T15:54:18","modified_gmt":"2025-05-12T15:54:18","slug":"how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search","status":"publish","type":"post","link":"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/","title":{"rendered":"How You Can Use Wildcards in Microsoft Excel to Refine Your Search"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_68_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >\u062c\u062f\u0648\u0644 \u0627\u0644\u0645\u062d\u062a\u0648\u064a\u0627\u062a<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#The_Wildcards_Asterisk_and_Question_Mark\" title=\"The Wildcards: Asterisk (*) and Question Mark (?)\">The Wildcards: Asterisk (*) and Question Mark (?)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#The_Asterisk_Wildcard_Any_Number_of_Characters\" title=\"The Asterisk Wildcard: Any Number of Characters\">The Asterisk Wildcard: Any Number of Characters<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#The_Question_Mark_Wildcard_Any_Single_Character\" title=\"The Question Mark Wildcard: Any Single Character\">The Question Mark Wildcard: Any Single Character<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#Question_Mark_and_Asterisk_Wildcards_Combined\" title=\"Question Mark and Asterisk Wildcards Combined\">Question Mark and Asterisk Wildcards Combined<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#Canceling_Wildcards_Tilde\" title=\"Canceling Wildcards: Tilde (~)\">Canceling Wildcards: Tilde (~)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#Using_Wildcards_in_Searches\" title=\"Using Wildcards in Searches\">Using Wildcards in Searches<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#Find_Character_Strings\" title=\"Find Character Strings\">Find Character Strings<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#Find_And_Replace_Character_Strings\" title=\"Find And Replace Character Strings\">Find And Replace Character Strings<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#Using_Wildcards_in_Formulas\" title=\"Using Wildcards in Formulas\">Using Wildcards in Formulas<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#Using_Wildcards_in_Filters\" title=\"Using Wildcards in Filters\">Using Wildcards in Filters<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/#Points_to_Note\" title=\"Points to Note\">Points to Note<\/a><\/li><\/ul><\/nav><\/div>\n<div>\n<p>Wildcards in Microsoft Excel let you search for partial matches, broaden your filters, and create formulas that reference cells containing certain strings. They represent non-specified characters to help you locate text values with &#8220;fuzzy&#8221; matches.<\/p>\n<p>    <!-- Not injecting Ads due to No-Ads mode. --><!-- Not injecting Ads due to No-Ads mode. --><\/p>\n<h2 id=\"the-wildcards-asterisk-and-question-mark\">\n                        The Wildcards: Asterisk (*) and Question Mark (?)<br \/>\n               <\/h2>\n<p>There are two wildcards in Excel, and knowing their purpose is crucial to understanding how wildcards work overall.<\/p>\n<h3 id=\"the-asterisk-wildcard-any-number-of-characters\">\n            The Asterisk Wildcard: Any Number of Characters<br \/>\n    <\/h3>\n<p>The first of the two wildcards in Microsoft Excel is an asterisk, which represents any number of characters, including no characters.<\/p>\n<p>For example:<\/p>\n<ul>\n<li>\n                                        *OK* matches with any cells that contain &#8220;OK,&#8221; with any number of characters before or after (including no characters).\n                        <\/li>\n<li>\n                                        OK* matches with any cells that start with &#8220;OK,&#8221; with any number of characters (including no characters) after, but nothing before.\n                        <\/li>\n<li>\n                                        *OK matches with any cells that end with &#8220;OK,&#8221; with any number of characters (including no characters) before.\n                        <\/li>\n<\/ul>\n<div class=\"table-container\">\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"\" align=\"\" summary=\"\">\n<thead>\n<tr>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Value to Test<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: *OK*<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: OK*<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: *OK<\/p>\n<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\n<p><strong>OK<\/strong><\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Oklahoma<\/strong><\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Shook<\/strong><\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Look<\/strong><\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Looking<\/strong><\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<h3 id=\"the-question-mark-wildcard-any-single-character\">\n            The Question Mark Wildcard: Any Single Character<br \/>\n    <\/h3>\n<p>Microsoft Excel&#8217;s second wildcard is the question mark, which substitutes any single character.<\/p>\n<p>For example:<\/p>\n<ul>\n<li>\n                                        ?OK? matches with any cells that contain a single character before &#8220;OK,&#8221; and a single character after.\n                        <\/li>\n<li>\n                                        OK? matches with any cells that contain a single character after &#8220;OK&#8221;, but nothing before.\n                        <\/li>\n<li>\n                                        ?OK matches with any cells that contain a single character before &#8220;OK&#8221;, but nothing after.\n                        <\/li>\n<\/ul>\n<div class=\"table-container\">\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"\" align=\"\" summary=\"\">\n<thead>\n<tr>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Value to Test<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: ?OK?<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: OK*<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: ?OK<\/p>\n<\/th>\n<\/tr>\n<tr>\n<td>\n<p><strong>Joke<\/strong><\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Oka<\/strong><\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Wok<\/strong><\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<\/tr>\n<\/thead>\n<\/table><\/div>\n<h3 id=\"question-mark-and-asterisk-wildcards-combined\">\n            Question Mark and Asterisk Wildcards Combined<br \/>\n    <\/h3>\n<p>You can also use the question mark and asterisk together to find results that have finite numbers of characters in some positions, but any number of characters in others.<\/p>\n<p>For example,<\/p>\n<ul>\n<li>\n                                        ??OK* matches with any cells that begin with two characters, then contain &#8220;OK,&#8221; with any number of characters at the end (including none).\n                        <\/li>\n<li>\n                                        *OK? matches with any cells that begin with any number of characters (including none), then contain &#8220;OK,&#8221; and end with one more character.\n                        <\/li>\n<li>\n                                        ?OK* matches with any cells that begin with a single character, then contain &#8220;OK,&#8221; and have any number of characters (including none) thereafter.\n                        <\/li>\n<\/ul>\n<div class=\"table-container\">\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"\" align=\"\" summary=\"\">\n<thead>\n<tr>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Value to Test<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: ??OK*<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: *OK?<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: ?OK*<\/p>\n<\/th>\n<\/tr>\n<tr>\n<td>\n<p><strong>Took<\/strong><\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Books<\/strong><\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Spooky<\/strong><\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Poky<\/strong><\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>Jokes<\/strong><\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<\/tr>\n<\/thead>\n<\/table><\/div>\n<h2 id=\"canceling-wildcards-tilde\">\n                        Canceling Wildcards: Tilde (~)<br \/>\n               <\/h2>\n<p>Sometimes, you might actually want to search for question marks and asterisks as characters in their own right in your Excel worksheet. This is where the third wildcard character\u2014the tilde\u2014comes into play: simply place it before the question mark or asterisk to tell Excel you don&#8217;t want them to be treated as wildcards.<\/p>\n<p>For example:<\/p>\n<ul>\n<li>\n                                        *~? matches with any cells that contain any number of characters (including none) at the start, and a question mark at the end.\n                        <\/li>\n<li>\n                                        *~?* matches with any cells that contain any number of characters (including none) on either side of a question mark.\n                        <\/li>\n<li>\n                                        *~*? matches with any cells that start with any number of characters, followed by an asterisk, followed by a single character.\n                        <\/li>\n<\/ul>\n<div class=\"table-container\">\n<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" style=\"\" align=\"\" summary=\"\">\n<thead>\n<tr>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Value to Test<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: *~?<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: *~?*<\/p>\n<\/th>\n<th scope=\"col\" style=\"width:25%\">\n<p>    <span style=\"width:25%;height:0px;display:block;\"\/><\/p>\n<p>Criterion: *~*?<\/p>\n<\/th>\n<\/tr>\n<tr>\n<td>\n<p><strong>Dinner?<\/strong><\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>???k<\/strong><\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<\/tr>\n<tr>\n<td>\n<p><strong>D?*y<\/strong><\/p>\n<\/td>\n<td>\n<p>No match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<td>\n<p>Match<\/p>\n<\/td>\n<\/tr>\n<\/thead>\n<\/table><\/div>\n<h2 id=\"using-wildcards-in-searches\">\n                        Using Wildcards in Searches<br \/>\n               <\/h2>\n<p>One of the most common uses of wildcards in Microsoft Excel is to find characters in a workbook and, if needed, replace them with alternatives.<\/p>\n<div class=\"display-card  article article-card small  no-badge  active-content                      \" data-include-community-rating=\"false\" id=\"5a5a-4016-92cc8f8d8a52\" data-nosnippet=\"\">\n<div class=\"w-img \">\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  img-featured-4-pin-single-size-featured-secondary\" :66.666666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.jpg\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;Lucas Gouveia \\\/ How-To Geek&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"1200\" height=\"800\" loading=\"lazy\" decoding=\"async\" alt=\"Excel logo surrounded by various letters.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.jpg\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.jpg?resize=1200%2C800&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>                    <span data-field=\"label\" class=\"article-card-label\">Related<\/span><\/p>\n<div class=\"w-display-card-content regular article-block\">\n<h5 class=\"display-card-title \">\n<p>\t\t\tHow to Find and Replace Text and Numbers in Excel<\/p>\n<\/h5>\n<p class=\"display-card-excerpt\">The Find and Replace tool is a powerful and often forgotten feature of Excel.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<h3 id=\"find-character-strings\">\n            Find Character Strings<br \/>\n    <\/h3>\n<p>In this list of product codes, the letters at the beginning represent where the product was manufactured (AUS for Australia, UK for the United Kingdom, USA for the United States, and CAN for Canada), the first digit represents the relevant store department (1 is clothing, 2 is homeware, 3 is sports, and 4 is garden), and codes with a letter at the end are national sale only (A) or international sale only (B).<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :71.733333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"538\" loading=\"lazy\" decoding=\"async\" alt=\"A list of product codes and prices in Microsoft Excel.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C538&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p>Let&#8217;s say you want to find all the homeware products that are for national sale only.<\/p>\n<p>Press Ctrl+F to launch the Find tab of the Find And Replace dialog box, and in the Find What field, type:<\/p>\n<pre>*2??A<\/pre>\n<p>where<\/p>\n<ul>\n<li>\n                                        The asterisk and the number 2 tell Excel to search for cells that start with any number of characters, followed by the number 2. You need to use an asterisk here, since some countries are represented by two letters while others are represented by three.\n                        <\/li>\n<li>\n                                        The two question marks followed by the letter A tell Excel that the rest of the string must be made up of two characters and the letter A.\n                        <\/li>\n<\/ul>\n<p>Then, when you click &#8220;Find All,&#8221; you&#8217;ll see a list at the bottom of the Find And Replace dialog box that shows any results that match these criteria.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :71.733333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065249_648_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"538\" loading=\"lazy\" decoding=\"async\" alt=\"Wildcards being used in Excel&#039;s Find And Replace dialog box to find specific product codes.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065249_648_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065249_648_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C538&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<section class=\"emaki-custom-block emaki-custom-tip\" data-nosnippet=\"\">\n<div class=\"emaki-custom tip\" id=\"custom_block_36\">\n<div class=\"custom_block-content tip\">\n<p>Click any of the results in the Find And Replace dialog box to jump to the corresponding cell in your spreadsheet.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<p>Now, let&#8217;s say your aim is to return the codes for all clothing products that aren&#8217;t restricted to national or international sales only (in other words, codes that contain a country and a three-digit number starting with 1, but don&#8217;t end with a letter).<\/p>\n<p>In the Find What field, type:<\/p>\n<pre>*1??<\/pre>\n<p>However, when you click &#8220;Find All,&#8221; a product ending in a letter shows up in the result, suggesting there&#8217;s something missing from the criteria.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :72%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065249_924_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"540\" loading=\"lazy\" decoding=\"async\" alt=\"The result of a Find in Excel that returns an unwanted product code.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065249_924_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065249_924_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C540&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p>In fact, this happened because <em>part <\/em>of the erroneous code contains the substring you entered for the query. So, to exclude these and return only the codes that <em>fully<\/em> match your query, click &#8220;Options,&#8221; check &#8220;Match Entire Cell Contents,&#8221; and click &#8220;Find All&#8221; again.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :71.733333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_419_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"538\" loading=\"lazy\" decoding=\"async\" alt=\"The Match Entire Cell Contents checkbox in Excel&#039;s Find And Replace dialog box is checked, and the Final All button is selected.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_419_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_419_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C538&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> This time, only the desired results are displayed.<\/p>\n<h3 id=\"find-and-replace-character-strings\">\n            Find And Replace Character Strings<br \/>\n    <\/h3>\n<p>This Excel list shows respondents&#8217; all-time favorite soccer players. However, Maradona&#8217;s name has been spelled in three different ways, and you want to amend the incorrect ones.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :86.533333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_905_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"649\" loading=\"lazy\" decoding=\"async\" alt=\"A list of respondents&#039; favorite soccer players in Excel, with various spellings of Maradona highlighted.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_905_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_905_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C649&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p>First, press Ctrl+H to launch the Replace tab of the Find And Replace dialog box. Then, in the Find What field, type:<\/p>\n<pre>Mar*<\/pre>\n<p>since all incorrect spellings start with these three letters, and it&#8217;s the only name in the list that starts with this character string.<\/p>\n<p>Then, in the Replace With, type the correct spelling:<\/p>\n<pre>Maradona<\/pre>\n<p>and click &#8220;Replace All&#8221; to confirm the corrections.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :85.866666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_511_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"644\" loading=\"lazy\" decoding=\"async\" alt=\"Excel&#039;s Find And Replace dialog box, with Mar and an asterisk in the Find What field, and Maradona in the Replacr With Field.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_511_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_511_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C644&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p>Now, all cases of this player&#8217;s name are spelled correctly and consistently.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :85.733333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_569_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"643\" loading=\"lazy\" decoding=\"async\" alt=\"A list of respondents&#039; favorite soccer players in Excel, with Maradona spelled consistently on four occasions.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_569_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_569_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C643&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<h2 id=\"using-wildcards-in-formulas\">\n                        Using Wildcards in Formulas<br \/>\n               <\/h2>\n<p>As well as using wildcards in Excel&#8217;s Find And Replace dialog box, you can use them in arguments for various functions, such as XLOOKUP to generate a partial match lookup, COUNTIFS to count the number of cells that match multiple criteria, and many more.<\/p>\n<p>In this example, you want to use the SUMIF function to work out the total price of products originating in the UK.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :71.6%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_658_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"537\" loading=\"lazy\" decoding=\"async\" alt=\"A list of product codes in Excel, with all codes containing the letters UK highlighted.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_658_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065250_658_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C537&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<div class=\"display-card  article article-card small  no-badge  active-content                      \" data-include-community-rating=\"false\" id=\"6aac-49de-a02f95bda902\" data-nosnippet=\"\">\n<div class=\"w-img \">\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  img-featured-4-pin-single-size-featured-secondary\" :66.666666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.jp.jpeg\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;Lucas Gouveia \\\/ How-To Geek | Yaran \\\/ &lt;a href=\\&quot;https:\\\/\\\/www.shutterstock.com\\\/image-vector\\\/halftone-hand-shows-bulb-concept-creative-2287081133\\&quot; rel=\\&quot;noreferrer noopener\\&quot; target=\\&quot;_blank\\&quot;&gt;Shutterstock&lt;\\\/a&gt;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"1200\" height=\"800\" loading=\"lazy\" decoding=\"async\" alt=\"A hand with the Excel logo and a light bulb next to it, and an Excel spreadsheet in the background.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.jp.jpeg\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.jp.jpeg?resize=1200%2C800&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>                    <span data-field=\"label\" class=\"article-card-label\">Related<\/span><\/p>\n<div class=\"w-display-card-content regular article-block\">\n<h5 class=\"display-card-title \">\n<p>\t\t\tHow to Use SUMIF in Microsoft Excel<\/p>\n<\/h5>\n<p class=\"display-card-excerpt\">Do you want to add numbers but only if they meet your conditions? Use SUMIF!<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p>One way to do this would be to type:<\/p>\n<pre>=SUMIF(A2:A18,\"UK*\",B2:B18)<\/pre>\n<p>into a blank cell, where<\/p>\n<ul>\n<li>\n                                        <em>SUMIF<\/em> adds values together based on set criteria,\n                        <\/li>\n<li>\n                                        <em>A2:A18<\/em> is the range containing the values to be tested,\n                        <\/li>\n<li>\n                                        <em>&#8220;UK*&#8221;<\/em> tells Excel to find any cells in A2 to A18 starting with &#8220;UK,&#8221; followed by any number of characters, and\n                        <\/li>\n<li>\n                                        <em>B2:B18<\/em> is the array to sum.\n                        <\/li>\n<\/ul>\n<section class=\"emaki-custom-block emaki-custom-note\" data-nosnippet=\"\">\n<div class=\"emaki-custom note\" id=\"custom_block_66\">\n<div class=\"custom_block-content note\">\n<p>Wildcards and text values must always be placed in quotation marks in Excel formulas.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<\/section>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :32.666666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_573_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"245\" loading=\"lazy\" decoding=\"async\" alt=\"A SUMIF formula with wildcards in Excel to return the total price of all product codes starting with &#039;UK.&#039;\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_573_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_573_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C245&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> However, suppose you then want to find the total price of products from another country. In the example above, you would need to change the formula manually, a method that takes time and is more likely to result in error.<\/p>\n<p>Instead, type the criteria (in this case, &#8220;UK&#8221;) in a separate cell. Then, reference that cell in the formula, using the ampersand (&amp;) symbol to separate the cell reference from the wildcard embedded in quotation marks:<\/p>\n<pre>=SUMIF(A2:A18,<strong>D2&amp;\"*\"<\/strong>,B2:B18)<\/pre>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :32.533333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_801_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"244\" loading=\"lazy\" decoding=\"async\" alt=\"A SUMIF formula with a cell reference concatenated with a wildcard in Excel to return the total price of all product codes starting with &#039;UK.&#039;\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_801_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_801_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C244&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p>Now, when you change the country code, the total updates.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :27.066666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_674_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"203\" loading=\"lazy\" decoding=\"async\" alt=\"A SUMIF formula with a cell reference concatenated with a wildcard in Excel to return the total price of all product codes starting with &#039;AUS.&#039;\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_674_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_674_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C203&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<section class=\"emaki-custom-block emaki-custom-tip\" data-nosnippet=\"\">\n<\/section>\n<h2 id=\"using-wildcards-in-filters\">\n                        Using Wildcards in Filters<br \/>\n               <\/h2>\n<p>Another use of wildcards in Microsoft Excel is in filters.<\/p>\n<div class=\"display-card  article article-card small  no-badge  active-content                      \" data-include-community-rating=\"false\" id=\"5ea7-49d7-a220b7e35a45\" data-nosnippet=\"\">\n<div class=\"w-img \">\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  img-featured-4-pin-single-size-featured-secondary\" :66.666666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_77_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.jpg\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;Lucas Gouveia \\\/ How-To Geek | &lt;a href=\\&quot;https:\\\/\\\/www.shutterstock.com\\\/en\\\/image-photo\\\/bielsko-poland-0413-close-macbook-air-2290474047\\&quot; rel=\\&quot;noreferrer noopener\\&quot; target=\\&quot;_blank\\&quot;&gt;Kamil Zajaczkowski&lt;\\\/a&gt; \\\/ Shutterstock&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"1200\" height=\"800\" loading=\"lazy\" decoding=\"async\" alt=\"A laptop with the Microsoft Excel app.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_77_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.jpg\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_77_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.jpg?resize=1200%2C800&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p>                    <span data-field=\"label\" class=\"article-card-label\">Related<\/span><\/p>\n<div class=\"w-display-card-content regular article-block\">\n<h5 class=\"display-card-title \">\n<p>\t\t\tHow to Sort and Filter Data in Excel<\/p>\n<\/h5>\n<p class=\"display-card-excerpt\">Microsoft Excel has power sorting and filtering options. Here&#8217;s how to use them in your spreadsheet.<\/p>\n<\/p><\/div>\n<\/p><\/div>\n<p>Whether you&#8217;re working in a formatted Excel table or an unformatted range, select any cell in the array, and press Ctrl+Shift+L to add filter buttons.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :38.8%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_590_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"291\" loading=\"lazy\" decoding=\"async\" alt=\"An unformatted Excel table with filter buttons in the header row.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_590_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065251_590_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C291&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p> Now, let&#8217;s say you want to filter the product codes to include only those that contain the letter A at the end.<\/p>\n<p>To do this, click the Product_Code filter button, and in the Search field, type:<\/p>\n<pre>*A<\/pre>\n<p>to include all codes ending in the letter A. Since the asterisk wildcard is placed before the letter A in the search, it doesn&#8217;t pick up any product codes containing A at the start (such as AUS458) or in the middle (such as USA320B).<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :72.666666666667%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065252_378_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"545\" loading=\"lazy\" decoding=\"async\" alt=\"A filter search in Microsoft Excel that includes the asterisk wildcard to return only values ending in the letter A.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065252_378_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065252_378_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C545&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<p>Once you&#8217;ve previewed the results in the filter pop-up window, click &#8220;OK,&#8221; and see your data refined to match your criteria.<\/p>\n<div class=\"body-img landscape \">\n<div class=\"responsive-img  image-expandable  img-article-item\" :20.133333333333%\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065252_971_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" data-modal-id=\"single-image-modal\" data-modal-container-id=\"single-image-modal-container\" data-img-caption=\"&quot;&quot;\">\n<figure>\n        <picture><source media=\"(min-width: 1024px)\" data- \/><source media=\"(min-width: 768px)\" data- \/><source media=\"(min-width: 481px)\" data- \/><source media=\"(min-width: 0px)\" data- \/><img data-recalc-dims=\"1\" width=\"750\" height=\"151\" loading=\"lazy\" decoding=\"async\" alt=\"Some Excel data is filtered using a wildcard to include only values ending in the letter A.\" data-img-url=\"https:\/\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065252_971_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png\" src=\"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065252_971_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?resize=750%2C151&#038;ssl=1\" style=\"display:block;height:auto;max-width:100%;\" title=\"\">\n    <\/picture>\n<\/figure><\/div>\n<\/p><\/div>\n<h2 id=\"points-to-note\">\n                        Points to Note<br \/>\n               <\/h2>\n<p>Before you go ahead and make use of wildcards in your Excel spreadsheet, take a moment to read these final pointers:<\/p>\n<ul>\n<li>\n                                        When using wildcards in formulas, you&#8217;ll hit a hurdle if you try to find a digit in a range of numbers. This is because wildcards automatically convert numbers to text. However, searching for digits in a range of numbers using Excel&#8217;s Find And Replace tool or filters will work just fine, as will finding numbers in cells that also contain text values.\n                        <\/li>\n<li>\n                                        Although many functions support the use of wildcards, some\u2014including the IF function\u2014don&#8217;t.\n                        <\/li>\n<li>\n                                        Adding wildcards to formulas makes them more complicated, potentially increasing the risk of errors if you don&#8217;t take extra care. Always remember to embed wildcards within quotation marks in formulas!\n                        <\/li>\n<\/ul>\n<hr\/>\n<p>As well as using wildcards to broaden your search capabilities in Excel, you can also use them to find and replace text in Microsoft Word. The major difference between the two is that, alongside the asterisk and question mark, Word also lets you use square brackets (( )) as wildcards to match more than one item.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Wildcards in Microsoft Excel let you search for partial matches, broaden your filters, and create formulas that reference cells containing certain strings. They represent non-specified characters to help you locate text values with &#8220;fuzzy&#8221; matches. The Wildcards: Asterisk (*) and Question Mark (?) There are two wildcards in Excel, and knowing their purpose is crucial &#8230; <a title=\"How You Can Use Wildcards in Microsoft Excel to Refine Your Search\" class=\"read-more\" href=\"https:\/\/goodwriterz.com\/site\/how-you-can-use-wildcards-in-microsoft-excel-to-refine-your-search\/\" aria-label=\"Read more about How You Can Use Wildcards in Microsoft Excel to Refine Your Search\">\u0625\u0642\u0631\u0623 \u0627\u0644\u0645\u0632\u064a\u062f<\/a><\/p>\n","protected":false},"author":1,"featured_media":104865,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[24],"tags":[39,313,288],"class_list":["post-104864","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft","tag-microsoft","tag-microsoft-365","tag-microsoft-excel"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/goodwriterz.com\/site\/wp-content\/uploads\/2025\/05\/1747065252_How-You-Can-Use-Wildcards-in-Microsoft-Excel-to-Refine.png?fit=1920%2C1080&ssl=1","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/104864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/comments?post=104864"}],"version-history":[{"count":0,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/posts\/104864\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media\/104865"}],"wp:attachment":[{"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/media?parent=104864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/categories?post=104864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodwriterz.com\/site\/wp-json\/wp\/v2\/tags?post=104864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}