{"id":4776,"date":"2017-12-07T03:21:13","date_gmt":"2017-12-07T03:21:13","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=4776"},"modified":"2023-10-23T18:30:38","modified_gmt":"2023-10-23T18:30:38","slug":"11-examples-learn-excel-find-search-functions-minor-difference","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/","title":{"rendered":"What are Excel FIND and SEARCH functions?"},"content":{"rendered":"<p class=\"has-left-border-and-background-color\">In summary, both FIND and SEARCH are useful for text searching in Excel, but they differ in case sensitivity and wildcard support. Use FIND when case-sensitivity matters, and SEARCH for case-insensitive searches with wildcard capabilities.<\/p>\n<p>Suppose we have a sentence \u201cExcel has plenty of functions.\u201d<\/p>\n<p>We want to find the position of \u201cplenty\u201d in that sentence. The position means from which number the plenty is starting in that sentence.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4779\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.3-Excel-FIND.png\" alt=\"Excel FIND\" width=\"309\" height=\"283\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.3-Excel-FIND.png 309w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.3-Excel-FIND-300x275.png 300w\" sizes=\"(max-width: 309px) 100vw, 309px\" \/><\/p>\n<p><strong>This is what Excel SEARCH and FIND functions are built for.<\/strong> Both functions take three arguments; two should already be clear. See the syntax of FIND and SEARCH that is almost the same:<\/p>\n<blockquote><p>FIND(Text_to_search, Source_Text, [start_num])<\/p>\n<p>SEARCH(find_text,within_text,[start_num])<\/p><\/blockquote>\n<ul>\n<li><strong>Text to search<\/strong> \u2013 \u201cPlenty\u201d in our example sentence.<\/li>\n<li><strong>Source_Text<\/strong> \u2013 The sentence we used. Naturally, this can be a cell reference.<\/li>\n<li>The third optional parameter is <strong>start number<\/strong>. It specifies what position you want to start searching in the Source text. For example, we want to search \u201cc\u201d in above sentence from 6 number. I will show this in the example to make things clear.<\/li>\n<li>If the <strong>find_text<\/strong> is not found, a <strong>#VALUE!<\/strong> Error occurs that you may be managed by using <a href=\"\/excel-iferror-function-explained-vlookup-examples\/\">IFERROR<\/a>.<\/li>\n<\/ul>\n<h3><strong>The Difference between SEARCH and FIND in Excel<\/strong><\/h3>\n<p>There are two differences:<\/p>\n<table width=\"794\">\n<tbody>\n<tr>\n<td style=\"text-align: center;\" width=\"475\"><strong>FIND<\/strong><\/td>\n<td style=\"text-align: center;\" width=\"319\"><strong>SEARCH<\/strong><\/td>\n<\/tr>\n<tr>\n<td>The FIND is case-sensitive. The \u2018C\u2019 and \u2018c\u2019 have different meanings if you use FIND function to get the position of text in the source string.<\/td>\n<td>The SEARCH function is case-insensitive.<\/td>\n<\/tr>\n<tr>\n<td>You may not use the \u2018*\u2019 and \u2018?\u2019 wildcards in the FIND function.<\/td>\n<td>SEARCH function allows the use of wildcards.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>See the following section for examples to learn both functions and understand the difference.<\/p>\n<h3><strong>An example of FIND function<\/strong><\/h3>\n<p>Let me start with a simple example of using a sentence and finding a word\u2019s position in that sentence. The FIND formula is applied in the D11 cell as follows:<\/p>\n<blockquote>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">=FIND(\"Name\",\"My Name is Ben\")<\/pre>\n<\/blockquote>\n<p><strong>The result:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4777\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png\" alt=\"Excel FIND text\" width=\"375\" height=\"283\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png 375w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text-300x226.png 300w\" sizes=\"(max-width: 375px) 100vw, 375px\" \/><\/p>\n<p>The word \u201cName\u201d is starting at position 4 in the given sentence.<\/p>\n<p>[stextbox id='info' bwidth='2' color='f7f2f2' bcolor='d9bd6a' bgcolor='360b0b' bgcolorto='5e4444']Did you know, the Excel has FINDB and SEARCHB functions that works with languages that use double-byte characters set (DBCS). FIND\/SEARCH is for single-byte characters set (SBCS) - count each character as 1.[\/stextbox]<\/p>\n<h3><strong>Excel FIND function is a case-sensitive example<\/strong><\/h3>\n<p>Now, let us see the example of the FIND function as case-sensitive. Using the same sentence as above except we will find the location of \u201cname\u201d:<\/p>\n<blockquote>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">=FIND(\"name\",\"My Name is Ben\")<\/pre>\n<\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4778\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.2-Excel-FIND-case-sensit.png\" alt=\"Excel FIND case sensit\" width=\"381\" height=\"281\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.2-Excel-FIND-case-sensit.png 381w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.2-Excel-FIND-case-sensit-300x221.png 300w\" sizes=\"(max-width: 381px) 100vw, 381px\" \/><\/p>\n<p>You see, a <strong>#VALUE!<\/strong>\u00a0error occurred as we changed the case of \u2018N\u2019 to \u2018n\u2019 in the FIND function.<\/p>\n<h3><strong>Using the FIND function in a cell text<\/strong><\/h3>\n<p>In this example, I will use the FIND function to search for the position of a letter in the <strong>A7<\/strong> cell. The A column contains the names of employees for the demo only:<\/p>\n<p>The FIND formula:<\/p>\n<blockquote>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">=FIND(\"h\",A7)<\/pre>\n<\/blockquote>\n<p><strong>The resultant sheet:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4779\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.3-Excel-FIND.png\" alt=\"Excel FIND\" width=\"309\" height=\"283\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.3-Excel-FIND.png 309w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.3-Excel-FIND-300x275.png 300w\" sizes=\"(max-width: 309px) 100vw, 309px\" \/><\/p>\n<p>You can see the location of \u2018h\u2019 is 2 in the A1 text = Shabee<\/p>\n<h3><strong>The example of Start_Num argument in FIND function<\/strong><\/h3>\n<p>For the start_num parameter example, the text in B3 cell is searched. The B3 contains the following text:<\/p>\n<p><em>\"IT Expert \/ Excel \/ Powerpoint \/ Word\"<\/em><\/p>\n<p>We searched \u2018p\u2019 that occurs at positions 6 and 26. However, the <em>start_num<\/em> argument is specified as below, and see the result:<\/p>\n<blockquote><p>=FIND(B10,B3,8)<\/p><\/blockquote>\n<p><strong>The result:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4780\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.4-FIND-Start_num.png\" alt=\"FIND Start_num\" width=\"464\" height=\"295\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.4-FIND-Start_num.png 464w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.4-FIND-Start_num-300x191.png 300w\" sizes=\"(max-width: 464px) 100vw, 464px\" \/><\/p>\n<p>You see, it returned 26 because FIND started searching from position 8.<\/p>\n<h3><strong>Handling the error if text is not found by the IFERROR function<\/strong><\/h3>\n<p>Rather than showing an error message if the given search term is not found, you may use the <a href=\"\/excel-iferror-function-explained-vlookup-examples\/\">IFERROR function<\/a> with FIND for displaying a descriptive message e.g. \u201cSearch term not found\u201d.<\/p>\n<p>See an example below where a user may enter any text in the B10 cell.<\/p>\n<p>The entered text will be searched in the <strong>B3<\/strong> cell. I used the IFERROR\/FIND combination and entered various texts including those that do not exist. Have a look at the formula and results:<\/p>\n<p><strong>The Formula:<\/strong><\/p>\n<blockquote>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">=IFERROR(FIND(B10,B3), \"Given text is not found!\")<\/pre>\n<\/blockquote>\n<p><strong>The results:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4781\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.4-Excel-FIND-IFERROR.png\" alt=\"Excel FIND IFERROR\" width=\"480\" height=\"288\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.4-Excel-FIND-IFERROR.png 480w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.4-Excel-FIND-IFERROR-300x180.png 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4782\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.5-Excel-FIND-IFERROR-2.png\" alt=\"Excel FIND IFERROR 2\" width=\"461\" height=\"95\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.5-Excel-FIND-IFERROR-2.png 461w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.5-Excel-FIND-IFERROR-2-300x62.png 300w\" sizes=\"(max-width: 461px) 100vw, 461px\" \/><\/p>\n<p>See another one with an <a href=\"https:\/\/www.excel-learn.com\/excel-iferror-function-explained-vlookup-examples\/\">IFERROR<\/a> message:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4783\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.6-Excel-FIND-IFERROR-msg.png\" alt=\"Excel FIND IFERROR msg\" width=\"461\" height=\"93\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.6-Excel-FIND-IFERROR-msg.png 461w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.6-Excel-FIND-IFERROR-msg-300x61.png 300w\" sizes=\"(max-width: 461px) 100vw, 461px\" \/><\/p>\n<p>The Visio is not found in the B3 cell. Rather than showing an error, the \u201cGiven text is not found!\u201d message is displayed.<\/p>\n<p><em>[stextbox id='alert' bwidth='2' color='f7f2f2' bcolor='d9bd6a' bgcolor='360b0b' bgcolorto='5e4444']Note: If you copy\/paste this formula then carefully check the double quotes or a name error may occur.[\/stextbox]<\/em><\/p>\n<h3><strong>Excel SEARCH function<\/strong><\/h3>\n<p>All the above examples will work the same way if you just replace the word \u201cFIND\u201d with \u201cSEARCH\u201d except the case sensitive example. So, I will not go further with showing all these examples for SEARCH function again but proceed by showing how it is different from to FIND function.<\/p>\n<p>So let us first see the case-insensitive feature of the SEARCH function.<\/p>\n<p>For that, I am using the same sheet as in above example. In the SEARCH formula, I specified the B8 cell that contains the \u201cAccounts\u201d text. Have a look at the results as I search various texts by using this formula:<\/p>\n<p><strong>The SEARCH formula:<\/strong><\/p>\n<blockquote><p>=SEARCH(B10,B8)<\/p><\/blockquote>\n<p><strong>The results:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4784\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.7-Excel-SEARCH.png\" alt=\"Excel SEARCH\" width=\"462\" height=\"287\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.7-Excel-SEARCH.png 462w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.7-Excel-SEARCH-300x186.png 300w\" sizes=\"(max-width: 462px) 100vw, 462px\" \/><\/p>\n<p>You see, \"aCC\" is searched and its returned position is 1.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4785\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.7-SEARCH-Function.png\" alt=\"SEARCH Function\" width=\"443\" height=\"74\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.7-SEARCH-Function.png 443w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.7-SEARCH-Function-300x50.png 300w\" sizes=\"(max-width: 443px) 100vw, 443px\" \/><\/p>\n<p>\u2018T\u2019 is not used in \u201cAccounts\u201d yet SEARCH returned 't' position.<\/p>\n<p>Now searching the \u2018t\u2019:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4786\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.8-SEARCH-Function-case-insensitive.png\" alt=\"SEARCH Function case insensitive\" width=\"453\" height=\"74\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.8-SEARCH-Function-case-insensitive.png 453w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.8-SEARCH-Function-case-insensitive-300x49.png 300w\" sizes=\"(max-width: 453px) 100vw, 453px\" \/><\/p>\n<p>Same result!<\/p>\n<h3><strong>Using wildcards in the SEARCH function<\/strong><\/h3>\n<p>Taking further the same example, let us now check SEARCH with \u201c*\u201d and \u201c?\u201d wildcards. I just changed the searching cell from B8 back to B3:<\/p>\n<blockquote><p>=SEARCH(B10,B3)<\/p><\/blockquote>\n<p><strong>With * wildcard:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4787\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.9-SEARCH-Function-wildcard.png\" alt=\"SEARCH Function wildcard\" width=\"464\" height=\"277\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.9-SEARCH-Function-wildcard.png 464w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.9-SEARCH-Function-wildcard-300x179.png 300w\" sizes=\"(max-width: 464px) 100vw, 464px\" \/><\/p>\n<p><strong>With \u2018?\u2019 wildcard:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4788\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.10-SEARCH-Function-wildcard-2.png\" alt=\"SEARCH Function wildcard 2\" width=\"462\" height=\"94\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.10-SEARCH-Function-wildcard-2.png 462w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.10-SEARCH-Function-wildcard-2-300x61.png 300w\" sizes=\"(max-width: 462px) 100vw, 462px\" \/><\/p>\n<p>If I had used five \u2018?\u2019 leading question marks, the result would have been 1. Because\u00a0one \u2018?\u2019 replaces one character. Due to six, it picked the second occurrence of \u2018p\u2019 i.e. \u201cPower\u201d.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The FIND is case sensitive to return the position. The \u2018C\u2019 and \u2018c\u2019 has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the \u2018*\u2019 and \u2018?\u2019 wildcards in the FIND function.<\/p>\n","protected":false},"author":1,"featured_media":4777,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[142],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>11 Examples to Learn Excel Find and Search Functions (Minor Difference)<\/title>\n<meta name=\"description\" content=\"The FIND is case sensitive to return the position. The \u2018C\u2019 and \u2018c\u2019 has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the \u2018*\u2019 and \u2018?\u2019 wildcards in the FIND function.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"11 Examples to Learn Excel Find and Search Functions (Minor Difference)\" \/>\n<meta property=\"og:description\" content=\"The FIND is case sensitive to return the position. The \u2018C\u2019 and \u2018c\u2019 has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the \u2018*\u2019 and \u2018?\u2019 wildcards in the FIND function.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2017-12-07T03:21:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-23T18:30:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png\" \/>\n\t<meta property=\"og:image:width\" content=\"375\" \/>\n\t<meta property=\"og:image:height\" content=\"283\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"excelmaster\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"excelmaster\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/\"},\"author\":{\"name\":\"excelmaster\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"headline\":\"What are Excel FIND and SEARCH functions?\",\"datePublished\":\"2017-12-07T03:21:13+00:00\",\"dateModified\":\"2023-10-23T18:30:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/\"},\"wordCount\":939,\"publisher\":{\"@id\":\"https:\/\/www.excel-learn.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png\",\"articleSection\":[\"Excel Functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/\",\"url\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/\",\"name\":\"11 Examples to Learn Excel Find and Search Functions (Minor Difference)\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png\",\"datePublished\":\"2017-12-07T03:21:13+00:00\",\"dateModified\":\"2023-10-23T18:30:38+00:00\",\"description\":\"The FIND is case sensitive to return the position. The \u2018C\u2019 and \u2018c\u2019 has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the \u2018*\u2019 and \u2018?\u2019 wildcards in the FIND function.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#primaryimage\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png\",\"contentUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png\",\"width\":375,\"height\":283,\"caption\":\"Excel FIND text\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excel-learn.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What are Excel FIND and SEARCH functions?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"publisher\":{\"@id\":\"https:\/\/www.excel-learn.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.excel-learn.com\/#organization\",\"name\":\"Excel Tutorials\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png\",\"contentUrl\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png\",\"width\":227,\"height\":48,\"caption\":\"Excel Tutorials\"},\"image\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"},\"url\":\"https:\/\/www.excel-learn.com\/author\/jqueryaz\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"11 Examples to Learn Excel Find and Search Functions (Minor Difference)","description":"The FIND is case sensitive to return the position. The \u2018C\u2019 and \u2018c\u2019 has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the \u2018*\u2019 and \u2018?\u2019 wildcards in the FIND function.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/","og_locale":"en_US","og_type":"article","og_title":"11 Examples to Learn Excel Find and Search Functions (Minor Difference)","og_description":"The FIND is case sensitive to return the position. The \u2018C\u2019 and \u2018c\u2019 has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the \u2018*\u2019 and \u2018?\u2019 wildcards in the FIND function.","og_url":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/","og_site_name":"Excel Tutorials","article_published_time":"2017-12-07T03:21:13+00:00","article_modified_time":"2023-10-23T18:30:38+00:00","og_image":[{"width":375,"height":283,"url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png","type":"image\/png"}],"author":"excelmaster","twitter_misc":{"Written by":"excelmaster","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#article","isPartOf":{"@id":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/"},"author":{"name":"excelmaster","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3"},"headline":"What are Excel FIND and SEARCH functions?","datePublished":"2017-12-07T03:21:13+00:00","dateModified":"2023-10-23T18:30:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/"},"wordCount":939,"publisher":{"@id":"https:\/\/www.excel-learn.com\/#organization"},"image":{"@id":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#primaryimage"},"thumbnailUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png","articleSection":["Excel Functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/","url":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/","name":"11 Examples to Learn Excel Find and Search Functions (Minor Difference)","isPartOf":{"@id":"https:\/\/www.excel-learn.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#primaryimage"},"image":{"@id":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#primaryimage"},"thumbnailUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png","datePublished":"2017-12-07T03:21:13+00:00","dateModified":"2023-10-23T18:30:38+00:00","description":"The FIND is case sensitive to return the position. The \u2018C\u2019 and \u2018c\u2019 has different meanings if you use FIND method to get the position of text in source string. The SEARCH function is case-insensitive. You may not use the \u2018*\u2019 and \u2018?\u2019 wildcards in the FIND function.","breadcrumb":{"@id":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#primaryimage","url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png","contentUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2017\/12\/12.1-Excel-FIND-text.png","width":375,"height":283,"caption":"Excel FIND text"},{"@type":"BreadcrumbList","@id":"https:\/\/www.excel-learn.com\/11-examples-learn-excel-find-search-functions-minor-difference\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excel-learn.com\/"},{"@type":"ListItem","position":2,"name":"What are Excel FIND and SEARCH functions?"}]},{"@type":"WebSite","@id":"https:\/\/www.excel-learn.com\/#website","url":"https:\/\/www.excel-learn.com\/","name":"Excel Tutorials","description":"Tips, Solutions, Tricks","publisher":{"@id":"https:\/\/www.excel-learn.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.excel-learn.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.excel-learn.com\/#organization","name":"Excel Tutorials","url":"https:\/\/www.excel-learn.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png","contentUrl":"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2022\/10\/Excel-logo_4_30.png","width":227,"height":48,"caption":"Excel Tutorials"},"image":{"@id":"https:\/\/www.excel-learn.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3","name":"excelmaster","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excel-learn.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g","caption":"excelmaster"},"url":"https:\/\/www.excel-learn.com\/author\/jqueryaz\/"}]}},"_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/4776"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=4776"}],"version-history":[{"count":4,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/4776\/revisions"}],"predecessor-version":[{"id":9617,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/4776\/revisions\/9617"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/4777"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=4776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=4776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=4776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}