What is the use of MID Function in EXCEL?

The Excel MID function extracts a given number of characters from the middle of a supplied text string. For example, =MID(“apple”,2,3) returns “ppl”.

  • Purpose: Extract text from inside a string
  • Return value: The characters extracted.


=MID (text, start_num, num_chars)


  • text - The text to extract from.
  • start_num - The location of the first character to extract.
  • num_chars - The number of characters to extract.


The formula below returns 3 characters starting at the 5th character:

=MID("The cat in the hat",5,3) // returns "cat"