MID Formula

MID formula extracts a character/Text  from a text on the base of given parameters.

Syntax for MID formula

MID( text, start_num, num_chars )

Parameters Details:

  • text: The string that you wish to extract from.
  • start_num: The position in the string that you will begin extracting from. The first position in the string is 1.
  • num_chars: The number of characters that you wish to extract.

Returns

The MID function returns a string/text value.

MID formula example
MID formula example