Find Text Between Two Strings

Find Text Between Two Strings

This function is useful for returning a portion of a string between two points in the string. You could, for example, extract a range name returned by Excel found between parentheses:

 Function Between(sText As String, sStart As _	String, sEnd As String) As String	Dim lLeft As Long, lRight As Long	lLeft = InStr(sText, sStart) + (Len(sStart) - 1)	lRight = InStr(lLeft + 1, sText, sEnd)	If lRight > lLeft Then Between = _		Mid$(sText, lLeft + 1, ((lRight - 1) - lLeft))End Function

Note that it only works for the first occurrences of the start and stop delimiters.

See also  Small Business Strategies with Venmo

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist