{"id":3194,"date":"2014-03-03T20:09:23","date_gmt":"2014-03-03T14:39:23","guid":{"rendered":"http:\/\/trumpexcel.com\/?page_id=3194"},"modified":"2023-11-23T13:21:19","modified_gmt":"2023-11-23T07:51:19","slug":"excel-find-function","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/excel-find-function\/","title":{"rendered":"How to Use Excel FIND Function (Examples + Video)"},"content":{"rendered":"<h2><span class=\"ez-toc-section\" id=\"Excel-FIND-Function-Example-Video\"><\/span><span style=\"color: #800000;\">Excel FIND Function (Example + Video)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-3254\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/FIND-FORMULA-EXCEL.png\" alt=\"Excel FIND Function\" width=\"450\" height=\"330\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/FIND-FORMULA-EXCEL.png 752w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/FIND-FORMULA-EXCEL-409x300.png 409w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">This Tutorial Covers:<\/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 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#Excel-FIND-Function-Example-Video\" >Excel FIND Function (Example + Video)<\/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:\/\/trumpexcel.com\/excel-find-function\/#When-to-use-Excel-FIND-Function\" >When to use Excel FIND Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#What-it-Returns\" >What it Returns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#Syntax\" >Syntax<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#Input-Arguments\" >Input Arguments<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#Additional-Notes\" >Additional Notes<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#Excel-FIND-Function-%E2%80%93-Examples\" >Excel FIND Function &#8211; Examples<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#Searching-for-a-Word-in-a-Text-String-from-the-beginning\" >Searching for a Word in a Text String (from the beginning)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#Finding-a-Word-in-a-Text-String-with-a-specified-beginning\" >Finding a Word in a Text String (with a specified beginning)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#When-there-are-Multiple-Occurrence-of-the-Searched-Text\" >When there are Multiple Occurrence of the Searched Text<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#Extracting-Everything-to-the-Left-a-Specified-CharacterString\" >Extracting Everything to the Left a Specified Character\/String<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#Excel-FIND-Function-%E2%80%93-VIDEO\" >Excel FIND Function &#8211; VIDEO<\/a><\/li><\/ul><\/nav><\/div>\n\n<h3><span class=\"ez-toc-section\" id=\"When-to-use-Excel-FIND-Function\"><\/span><span style=\"color: #800000;\">When to use Excel FIND Function<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Excel FIND function can be used when you want to locate a text string within another text string and find its position.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What-it-Returns\"><\/span><span style=\"color: #800000;\">What it Returns<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>It returns a number that represents the starting position of the string you are finding in another string.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Syntax\"><\/span><span style=\"color: #800000;\">Syntax<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>=FIND(find_text, within_text, [start_num])<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Input-Arguments\"><\/span><span style=\"color: #800000;\">Input Arguments<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>find_text &#8211; the text or string that you need to find.<\/li>\n<li>within_text &#8211; the text within which you want to find the find_text argument.<\/li>\n<li>[start_num] &#8211; a number that represents the position from which you want the search to begin. If you omit it, it starts from the beginning.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Additional-Notes\"><\/span><span style=\"color: #800000;\">Additional Notes<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>If the start number is not specified, then it starts looking from the beginning of the string.<\/li>\n<li>Excel FIND function is <b><i>case-sensitive. <\/i><\/b>If you want to do a case-insensitive search, use <a href=\"https:\/\/trumpexcel.com\/excel-search-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel SEARCH function<\/a>.<\/li>\n<li><b><i><\/i><\/b>Excel FIND function <b><i>cannot handle <a href=\"https:\/\/trumpexcel.com\/excel-wildcard-characters\/\" target=\"_blank\" rel=\"noopener noreferrer\">wildcard characters<\/a>.\u00a0<\/i><\/b>If you want to use wildcard characters, use the Excel SEARCH function.<\/li>\n<li>It returns a #VALUE! error if the searched string is not found in the text.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Excel-FIND-Function-%E2%80%93-Examples\"><\/span><span style=\"text-decoration: underline;\"><span style=\"color: #800000; text-decoration: underline;\">Excel FIND Function &#8211; Examples<\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Here are four examples of using Excel FIND function:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Searching-for-a-Word-in-a-Text-String-from-the-beginning\"><\/span><span style=\"color: #800000;\">Searching for a Word in a Text String (from the beginning)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img decoding=\"async\" class=\"size-full wp-image-13080 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-FIND-Function-Example-1.png\" alt=\"Excel FIND Function - Example 1\" width=\"716\" height=\"230\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-FIND-Function-Example-1.png 716w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-FIND-Function-Example-1-600x193.png 600w\" sizes=\"(max-width: 716px) 100vw, 716px\" \/><\/p>\n<p>In the above example, when you look for the word <span style=\"color: #0000ff;\">Good<\/span> in the text <span style=\"color: #0000ff;\">Good Morning<\/span>, it returns 1, which is the position of the starting point of the searched word.<\/p>\n<p>Note that Excel FIND function is <span style=\"text-decoration: underline;\">case-sensitive<\/span>.\u00a0When you use <span style=\"color: #0000ff;\">good<\/span> instead of <span style=\"color: #0000ff;\">Good<\/span>, it returns a #VALUE! error.<\/p>\n<p>If you are looking for a case-insensitive search, use Excel SEARCH function.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Finding-a-Word-in-a-Text-String-with-a-specified-beginning\"><\/span><span style=\"color: #800000;\">Finding a Word in a Text String (with a specified beginning)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img decoding=\"async\" class=\"size-full wp-image-13082 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-FIND-Function-Example-2.png\" alt=\"Excel FIND Function - Example 2\" width=\"717\" height=\"257\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-FIND-Function-Example-2.png 717w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-FIND-Function-Example-2-600x215.png 600w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/p>\n<p>The third argument in the FIND function is the position within the text from where you want to start the search. In the example above, the function returns 1 when you search for the text <span style=\"color: #0000ff;\">Good<\/span> in <span style=\"color: #0000ff;\">Good Morning<\/span> and the starting position is 1.<\/p>\n<p>However, it returns an error when you make it start at 2. Hence, it looks for the text <span style=\"color: #0000ff;\">Good<\/span> in <span style=\"color: #0000ff;\">ood\u00a0Morning<\/span>. Since it can not find it, it returns an error.<\/p>\n<p><em>Note: If you skip the last argument and don&#8217;t provide the starting position, by default it\u00a0takes it as 1.<\/em><\/p>\n<h3><span class=\"ez-toc-section\" id=\"When-there-are-Multiple-Occurrence-of-the-Searched-Text\"><\/span><span style=\"color: #800000;\">When there are Multiple Occurrence of the Searched Text<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13083 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-FIND-Function-Example-3.png\" alt=\"Excel FIND Function - Example 3\" width=\"719\" height=\"285\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-FIND-Function-Example-3.png 719w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-FIND-Function-Example-3-600x238.png 600w\" sizes=\"(max-width: 719px) 100vw, 719px\" \/><\/p>\n<p>Excel FIND function starts looking in the specified text from the specified position. In the above example, when you look for the text <span style=\"color: #0000ff;\">Good<\/span> in <span style=\"color: #0000ff;\">Good Good Morning<\/span> with the starting position as 1, it returns 1, as it finds it at the beginning.<\/p>\n<p>When you start the search from the second character onwards, it returns 6, as it finds the matching text at the sixth position.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Extracting-Everything-to-the-Left-a-Specified-CharacterString\"><\/span>Extracting Everything to the Left a Specified Character\/String<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Suppose you have the email ids do some superheroes as shown below and you want to extract only the username part (which would be the characters before the @).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22821 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extract-Usernames-using-Excel-FIND-Function.jpg\" alt=\"Extract Usernames using Excel FIND Function\" width=\"366\" height=\"205\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extract-Usernames-using-Excel-FIND-Function.jpg 366w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extract-Usernames-using-Excel-FIND-Function-50x28.jpg 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extract-Usernames-using-Excel-FIND-Function-250x140.jpg 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extract-Usernames-using-Excel-FIND-Function-179x100.jpg 179w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extract-Usernames-using-Excel-FIND-Function-357x200.jpg 357w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extract-Usernames-using-Excel-FIND-Function-268x150.jpg 268w\" sizes=\"(max-width: 366px) 100vw, 366px\" \/><\/p>\n<p>Below is the formula that will find the position of &#8216;@&#8217; in each email id and extract all the characters to the left of it:<\/p>\n<p>=LEFT(A2,FIND(&#8220;@&#8221;,A2,1)-1)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-22822 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extarcting-the-usernames-using-FIND-and-LEFT-functions.jpg\" alt=\"Extracting the usernames using FIND and LEFT functions\" width=\"542\" height=\"250\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extarcting-the-usernames-using-FIND-and-LEFT-functions.jpg 542w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extarcting-the-usernames-using-FIND-and-LEFT-functions-50x23.jpg 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extarcting-the-usernames-using-FIND-and-LEFT-functions-250x115.jpg 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extarcting-the-usernames-using-FIND-and-LEFT-functions-217x100.jpg 217w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extarcting-the-usernames-using-FIND-and-LEFT-functions-400x185.jpg 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Extarcting-the-usernames-using-FIND-and-LEFT-functions-325x150.jpg 325w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/p>\n<p>The FIND function in this formula gives the position of the &#8216;@&#8217; character. The <a href=\"https:\/\/trumpexcel.com\/excel-left-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">LEFT function<\/a> that uses this position to extract the username.<\/p>\n<p>For example, in the case of brucewayne@batman.com, the FIND function returns 11. LEFT function then uses\u00a0<span style=\"color: #0000ff;\">FIND(&#8220;@&#8221;,A2,1)-1<\/span> as the second argument to get the username.<\/p>\n<p>Note that 1 is subtracted from the value returned by the FIND function as we want to exclude the @ from the result of the LEFT function.<\/p>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Excel-FIND-Function-%E2%80%93-VIDEO\"><\/span><span style=\"color: #800000;\">Excel FIND Function &#8211; VIDEO<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><iframe title=\"How to use FIND Formula in Excel\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/43L6SNVoGdM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p><span style=\"color: #800000;\"><strong>Related Excel Functions:<\/strong><\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-lower-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel LOWER Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-upper-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel UPPER Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-proper-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel PROPER Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-replace-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel REPLACE Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-search-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel SEARCH Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-substitute-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel SUBSTITUTE Function<\/a>.<\/li>\n<\/ul>\n<p><span style=\"color: #800000;\"><strong>You May Also Like the Following Tutorials:<\/strong><\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/find-hyperlinks-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Quickly Find and Remove Hyperlinks in Excel<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/find-merged-cells\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Find Merged Cells in Excel.<\/a><\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/find-and-remove-duplicates-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Find and Remove Duplicates in Excel.<\/a><\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/find-and-replace-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Using Find and Replace in Excel<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/check-if-cell-contains-partial-text-excel\/\" target=\"_blank\" rel=\"noopener\">Check IF Cell Contains Partial Text in Excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Excel FIND Function (Example + Video) When to use Excel FIND Function Excel FIND function can be used when you want to locate a text string within another text string and find its position. What it Returns It returns a number that represents the starting position of the string you are finding in another string. &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Use Excel FIND Function (Examples + Video)\" class=\"read-more button\" href=\"https:\/\/trumpexcel.com\/excel-find-function\/#more-3194\" aria-label=\"Read more about How to Use Excel FIND Function (Examples + Video)\">Read more<\/a><\/p>\n","protected":false},"author":80,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[153],"tags":[19],"class_list":["post-3194","post","type-post","status-publish","format-standard","hentry","category-excel-functions","tag-excel-how-tos"],"_links":{"self":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/3194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/users\/80"}],"replies":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/comments?post=3194"}],"version-history":[{"count":0,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/3194\/revisions"}],"wp:attachment":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/media?parent=3194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/categories?post=3194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/tags?post=3194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}