Excel Mid Function (VBA): Find a String of Characters
The Excel MID VBA function finds a string of characters in a Variant starting from the position you specify.
MID(stringvariable, starting point[, length])
StringVariable: Put a variable in that has the string
Starting Point: character to begin function at (integer)
Length: number of characters to replace, you can omit this)
Dim EditString As String
EditString = Activesheet.cells(10,3).value 'Sets the variable for the string
'For this example, say EditString = "test"
GetMID = Mid(editstring,2) 'Mid Function in use
GetMid returns "est" since you are starting at the 2nd character with the