tag:blogger.com,1999:blog-5359684994061749655.post3136130487039790521..comments2023-06-26T10:38:12.009+01:00Comments on TechieBird's Nest: Function for returning the nth occurrence of a substring in ExcelTechieBird:http://www.blogger.com/profile/09355855910922533526noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5359684994061749655.post-22109068914339022092012-09-30T17:32:32.809+01:002012-09-30T17:32:32.809+01:00Thanks Tycho, always glad to have my scripts impro...Thanks Tycho, always glad to have my scripts improved upon. And I love your parameter naming :)TechieBirdhttps://www.blogger.com/profile/14063723415099599508noreply@blogger.comtag:blogger.com,1999:blog-5359684994061749655.post-76805537058825066412012-09-25T08:01:50.598+01:002012-09-25T08:01:50.598+01:00I came across a similar issue, but needed an offse...I came across a similar issue, but needed an offset parameter as well (for the first search), so ended up writing my own version. It's slightly less verbose as well, so I figured it's worth sharing for others looking for a solution.<br /><br />Function InStrNr(ByVal offset As Long, haystack As String, needle As String, Optional occurrence As Integer = 1) As Long<br />Dim i As Integer<br />For i = 1 To occurrence<br /> offset = InStr(offset + 1, haystack, needle)<br />Next i<br />InStrNr = offset<br />End Function<br />Tychohttps://www.blogger.com/profile/03970046984378081068noreply@blogger.com