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)

Example:

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

MID function