{"id":12188,"date":"2014-06-08T22:00:39","date_gmt":"2014-06-08T22:00:39","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=2875"},"modified":"2014-06-08T22:00:39","modified_gmt":"2014-06-08T22:00:39","slug":"vba-string-function-instr","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/","title":{"rendered":"VBA String Functions &#8211; INSTR() Function"},"content":{"rendered":"<h3>Instr() Function<\/h3>\n<p>This is a VBA function and not a Worksheet function (Excel formula). This function returns the <strong>Position of First Occurrence <\/strong> of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer value. As mentioned in the definition of this function, it always returns the position number of the very <\/strong>First<\/strong> occurrence. Once first occurrence found, search stops there and returns the position number. It does not go and check any other occurrence.<\/p>\n<h3>Syntax:<\/h3>\n<p>This is how Syntax will look like as soon as you type <strong>VBA.Instr <\/strong> in VB Editor<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/04\/Instr-Syntax.png\" alt=\"Instr - Syntax\" title=\"Instr - Syntax\" width=\"532\" height=\"50\" class=\"aligncenter size-full wp-image-3890\" \/><\/p>\n<h3>\nVBA.Instr(&lt;Start&gt;, &lt;String1&gt;, &lt;String2&gt;, &lt;CompareMethod&gt;)<\/h3>\n<h2>Parameters:<\/h2>\n<h3>Start(Optional) :<br \/>\n<\/h3>\n<p> This is the start position where you want to start the search of your sub-string to find its first occurrence in the main string. This is an optional argument. If omitted search starts from the first character of the main string.<\/p>\n<h3>String1(Mandatory) :<br \/>\n<\/h3>\n<p>This is the main string in which the sub-string is to be searched. This is a mandatory argument.<\/p>\n<h3>String2(Mandatory) :<\/h3>\n<p>This is the sub-string which has to be searched in the main string to find its first occurrence. This is again a mandatory argument.<\/p>\n<h3>CompareMethod (Optional) :<\/h3>\n<p>This is a Numeric value ( 0 or 1) to indicate which method to use for comparison. <strong>0<\/strong> is for performing a binary comparison. <strong>1<\/strong> is for performing a textual comparison. The default method is <strong>0 &#8211; vbBinaryCompare<\/strong><\/p>\n<h3>Examples:<\/h3>\n<p>With the above theory you may not be more comfortable until you practice with the some example by running the VBA code. I have taken few possible cases with different parameters in the below examples.  They will make you more comfortable in using this function \ud83d\ude42<\/p>\n<h2>Example 1 : Omitting all the Optional Parameters<\/h2>\n<p>In the below Example, I have omitted all the optional parameter and passed the <strong>String1 and String2<\/strong> which are the <strong>mandatory<\/strong> parameters in this function.<\/p>\n<p><strong>String1 : <\/strong> <i>My Name is Vishwa Mitra vishwa mishra<\/i><br \/>\n<strong>String2 : <\/strong> <i>vishwa<\/i><\/p>\n<p>&nbsp;<br \/>\nVBA.Instr function will look like below with the above 2 argument passed in it:<br \/>\n&nbsp;<br \/>\n<strong>VBA.Instr(&#8220;My Name is Vishwa Mitra vishwa mishra&#8221;, &#8220;vishwa&#8221;)<\/strong><br \/>\nFollowing picture shows the integer value which is returned by the above VBA statement (refer the below picture)<br \/>\n&nbsp;<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/04\/Instr-Example-1.png\" alt=\"Instr-Example-1\" title=\"Instr-Example-1\" width=\"661\" height=\"195\" class=\"aligncenter size-full wp-image-3892\" \/><\/p>\n<h3>Explanation:<\/h3>\n<p>In the above code all the optional parameters are omitted. Hence using all the default values for other parameters, this function has returned the first occurrence of sub-string <strong>vishwa<\/strong> in the main string. This function has returned the count as 12.<br \/>\nIn the above example default <i>Start<\/i> number is passed as 1 and compare method is passed as 0 &#8211; BinaryMethod.<\/p>\n<h2>Example 2 : What is difference between Binary and Text comparison?<\/h2>\n<p>It is very simple. As the name suggests in binary comparison, system compares the Numeric unicode value of each character. But in Text Comparison, comparison is based on the reference of the current world definition.<br \/>\n<strong>For example: <\/strong> Upper case &#8211; <strong>V<\/strong> and Lower case &#8211; <strong>v<\/strong>. Both &#8220;V&#8221; and &#8220;v&#8221; has different unicode value but as a text both are same. This is the reason Below statement 1 returns the first occurrence as 1 while the statement 2 returns as 8 while both the statements are exactly same except the comparison method. Refer the below two examples:<\/p>\n<h3>Statement 1: Text Comparison<\/h3>\n<p><i>SubStringFoundAt = VBA.InStr(1, &#8220;Vishwa vishwa Mitra mishra&#8221;, &#8220;vishwa&#8221;, 1)<\/i><br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/04\/Inst-Statement-1-Text-Compare.png\" alt=\"Instr - Statement 1 - Text Compare\" title=\"Instr - Statement 1 - Text Compare\" width=\"669\" height=\"191\" class=\"aligncenter size-full wp-image-3893\" \/><\/p>\n<h3>Statement 2: Binary Comparison<\/h3>\n<p><i>SubStringFoundAt = VBA.InStr(1, &#8220;Vishwa vishwa Mitra mishra&#8221;, &#8220;vishwa&#8221;, 0)<\/i><br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/04\/Inst-Statement-1-Binary-Compare.png\" alt=\"Instr - Statement 1 - Binary Compare\" title=\"Instr - Statement 1 - Binary Compare\" width=\"671\" height=\"191\" class=\"aligncenter size-full wp-image-3894\" \/><\/p>\n<blockquote><p>With the above example difference between Binary Comparison and Text Comparison is clear. Though, rest all the parameters are same in both the statement but still result is different because comparison method is different. Reason is that in Binary Comparison <strong>Vishwa<\/strong> is not equal to <strong>vishwa<\/strong> but in text comparison they are equal.\n<\/p><\/blockquote>\n<h2>Example 3 : Impact of Start number<\/h2>\n<p>In the below example I will show you how Start number has an impact on the integer returned by this function.<\/p>\n<pre><code class=\"language-vbnet\">\nFunction INSTR_EXAMPLE()\nDim myString As String\nDim SubStringFoundAt1 As Integer\nDim SubStringFoundAt2 As Integer\n    SubStringFoundAt1 = VBA.InStr(1, \"vishwa vishwa Mitra mishra\", \"vishwa\", 0)\n    SubStringFoundAt2 = VBA.InStr(2, \"vishwa vishwa Mitra mishra\", \"vishwa\", 0)\nEnd Function\n<\/code><\/pre>\n<p>In the above code first statement returns the integer as <strong>1<\/strong> while the second statement returns as <strong>8><\/strong> as shown in the below picture:<br \/>\n<img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/04\/Instr-Example-Start.png\" alt=\"Instr - Example - Start\" title=\"Instr - Example - Start\" width=\"685\" height=\"226\" class=\"aligncenter size-full wp-image-3895\" \/><\/p>\n<h3>Explanation:<\/h3>\n<p><strong> Case 1 : <\/strong>In the first statement the Start number is set as <strong>1<\/strong> hence <strong>Instr()<\/strong> function starts the search of sub-string <strong>vishwa<\/strong> right from the first letter of the main string <strong>vishwa vishwa Mitra mishra<\/strong> and it finds the first occurrence at the first place itself hence it returned the integer as <strong>1<\/strong><br \/>\n<strong> Case 2 : <\/strong>In the second statement start number is passed as <strong>2<\/strong>; it means the Instr() VBA function will start the search from the second letter of the string <strong>vishwa vishwa Mitra mishra<\/strong>. This is the reason in this case this function will find the first occurrence of sub-string <strong>vishwa<\/strong> at the 8th position and it returned the integer as <strong>8<\/strong><\/p>\n<h3>Special Cases in INSTR()Function<\/h3>\n<p>Following are special cases in this function:<\/p>\n<h2>Case 1 : Sub-String NOT Found<\/h2>\n<p>Zero (0) is returned by Instr(), if the Sub-String is not found in the main string <i>from the <strong>start<\/strong> number for search provided in the parameter<\/i>. In the given example though the string <strong>vishwa<\/strong> is found but not starting from the 5th letter (Start=5) hence this function will consider as Sub-String NOT found in the main string and will return <strong>Zero (0)<\/strong> as shown in the below picture.<\/p>\n<h2>Case 2 : Main String passed with Zero length<\/h2>\n<p>Zero (0) is returned by Instr() function, if main string is passed of Zero length. Refer the below picture<\/p>\n<h2>Case 3 : Sub-String passed with Zero length<\/h2>\n<p>In this case this function returns the <strong>Start Number<\/strong> passed. Refer the below picture:<\/p>\n<h2>Case 4 : <i>Start<\/i>  > length of Main string AND Sub-String is NOT of Zero Length<\/h2>\n<p>In this case when <i>Start<\/i> number is greater than the length of the main string AND sub-string is NOT of Zero length, Zero is returned. Refer the below picture.<\/p>\n<pre><code class=\"language-vbnet\">\nFunction INSTR_EXAMPLE()\nDim myString As String\nDim Case1 As Integer\nDim Case2 As Integer\nDim Case3 As Integer\n    Case1 = VBA.InStr(5, \"vishwa Mitra mishra\", \"vishwa\", 0)\n    Case2 = VBA.InStr(1, \"\", \"vishwa\", 0)\n    Case3 = VBA.InStr(10, \"vishwa Mitra mishra\", \"\", 0)\n    Case4 = VBA.InStr(100, \"vishwa Mitra mishra\", \"vishwa\", 0)\nEnd Function\n<\/code><\/pre>\n<p><img decoding=\"async\" src=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2013\/04\/Instr-Special-Cases.png\" alt=\"Instr - Special -Cases\" title=\"Instr - Special -Cases\" width=\"659\" height=\"325\" class=\"aligncenter size-full wp-image-3896\" \/><\/p>\n<h2>Explanation:<\/h2>\n<p><strong>Case 1. <\/strong> It returns Zero because <strong>vishwa<\/strong> is NOT found in the string 5th letter (because Start = 5)<br \/>\n<strong>Case 2. <\/strong> Returns Zero because the length of the main string is Zero.<br \/>\n<strong>Case 3. <\/strong> In this case it returns the <strong>Start<\/strong> number passed in the function because the sub-string to be searched is of zero length.<br \/>\n<strong>Case 4. <\/strong> This returns Zero because the Start (100) is greater than the length of the main string (19) AND String2 is not of Zero length.<\/p>\n<h3>Have you got any question or doubt related to INSTR() Function? <\/h3>\n<p>Do comment of mail me. I try my best to clarify.<\/p>\n<span class=\"et_bloom_bottom_trigger\"><\/span>","protected":false},"excerpt":{"rendered":"<p>Instr() Function This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer value. As mentioned in the definition of this function, it [&hellip;]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.9 (Yoast SEO v21.9.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>VBA String Functions - INSTR() Function - Let&#039;s excel in Excel<\/title>\n<meta name=\"description\" content=\"This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer value.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"VBA String Functions - INSTR() Function\" \/>\n<meta property=\"og:description\" content=\"This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer value.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/\" \/>\n<meta property=\"og:site_name\" content=\"Let&#039;s excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-08T22:00:39+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2013\/04\/Instr-Syntax.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"VBA String Functions &#8211; INSTR() Function\",\"datePublished\":\"2014-06-08T22:00:39+00:00\",\"dateModified\":\"2014-06-08T22:00:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/\"},\"wordCount\":1039,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"articleSection\":[\"Excel Macro\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/\",\"name\":\"VBA String Functions - INSTR() Function - Let&#039;s excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"datePublished\":\"2014-06-08T22:00:39+00:00\",\"dateModified\":\"2014-06-08T22:00:39+00:00\",\"description\":\"This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer value.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"VBA String Functions &#8211; INSTR() Function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let&#039;s excel in Excel\",\"description\":\"Let&#039;s share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"VBA String Functions - INSTR() Function - Let&#039;s excel in Excel","description":"This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer value.","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:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/","og_locale":"en_US","og_type":"article","og_title":"VBA String Functions - INSTR() Function","og_description":"This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer value.","og_url":"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/","og_site_name":"Let&#039;s excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2014-06-08T22:00:39+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2013\/04\/Instr-Syntax.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"VBA String Functions &#8211; INSTR() Function","datePublished":"2014-06-08T22:00:39+00:00","dateModified":"2014-06-08T22:00:39+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/"},"wordCount":1039,"commentCount":0,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"articleSection":["Excel Macro"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/","url":"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/","name":"VBA String Functions - INSTR() Function - Let&#039;s excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"datePublished":"2014-06-08T22:00:39+00:00","dateModified":"2014-06-08T22:00:39+00:00","description":"This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First Occurrence of a SubString in a String. SubString could be a letter, Word or Sentence etc. It means this function always returns an Integer value.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2014\/06\/vba-string-function-instr\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"VBA String Functions &#8211; INSTR() Function"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let&#039;s excel in Excel","description":"Let&#039;s share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore &amp; currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/twitter.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12188"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12188"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12188\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}