MID

Definition: MID is a function that returns a specified number of characters from the middle of a text string.

Syntax: =MID(text, start_num, num_chars)

Situation: This formula is appropriate when you need to extract a specified number of characters from the middle of a text string.

Example: If you have a text string “apple”, and want to extract the middle three characters, the formula =MID(“apple”, 2, 3) can be used, which returns “ppl”.