Table of Contents
About
MID function in Excel returns the given number of characters from the middle of a text string.
Function Type
Text
Purpose
Extract characters from the specified position of a string.
Return value
Extracted characters
Syntax
=MID(text, start_num, num_chars)
Arguments
text – data from which characters are to be extracted.
start_num – position from which characters are to be extracted
num_chars – number of characters to be extracted.
Example
Notes
Number formatting is not a part of the text data. So, MID function will ignore $, % or any other characters displayed in cells using Number formatting in Excel.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)