Len, InStr & Mid functions.

What Do They Do?

Len - Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable.

InStr - Returns an integer specifying the start position of the first occurrence of one string within another. Returns the position of the first occurrence of one string within another.

Mid - Returns a specified number of characters from a string.

What data type do they return?

Len – integer characters in a string

InStr – return the position of the first occurrence of one string within another.

Mid - returns the characters while the Midstatement replaces the characters.

What parameters do they require?

Len - Any valid String expression or variable name
InStr - string being searched and being sought.
Mid - starting position of character, number of characters returned.