What is the use of MID Function in EXCEL?

[board-infinity]

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"