MID function in Excel returns the given number of characters from the middle of a text string.
Extract characters from the specified position of a string.
=MID(text, start_num, num_chars)
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.
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)
New Dynamic Array Functions in Excel