What is the use of MID Function in EXCEL?

Data Science, AI and ML
,
1

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.

Syntax

=MID (text, start_num, num_chars)

Arguments

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

Example;

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

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