how do I find all characters that follow a specific character in .

[Guest]

how do I find all characters that follow a specific character in a string?
Can I use Mid someway?

 

[Douglas J. Steele]

Mid(MyString, InStr(MyString, SpecialCharacter) + 1)

 

[Dirk Goldgar]

how do I find all characters that follow a specific character in a
string? Can I use Mid someway?

Example:

Dim strSource As String
Dim strTail As String

strSource = "abcdefghijklm#nopqrstuvwxyz"

' Get all characters following the "#" (not including it).
strTail = Mid(strSource, InStr(strSource, "#") + 1)