Consistency of structure is critical in string manipulation. Example:
Code:
Sub GetInfo()
Dim strS As String
strS = "The line I need is: 1) FirstName LastName https://classes.redcross.org/Saba/We...ficate?certid=something part of hyperlink/text before = will always be constant."
strS = Mid(strS, InStr(strS, ")") + 2)
Debug.Print Left(strS, InStr(strS, "http") - 2)
strS = Mid(strS, InStr(strS, "http"))
Debug.Print Left(strS, InStr(strS, " ") - 1)
End Sub
The output:
FirstName LastName
https://classes.redcross.org/Saba/We...ficate?certid=something