MID

Checks whether a condition is met, and returns one value if true and another value if false.

Syntax: MID ( text, starting_character, characters_to_extract )

• text is the string to extract a portion of the text from

• starting_character is the index of the first character from the left of text to begin extracting. The first character in text has the index 1.

• characters_to_extract is the length of the portion of a text to extract

Note: All three arguments (parameters) are required.

Example: MID ( "A1b2c3" , 2 , 3 ) Output: 1b2