How To Use MID Function | Microsoft Excel

How To Use MID Function | Microsoft Excel

MID Function


MID Function returns a specific range(From the middle of the text) of the characters from the string or text

Syntax of MID Function

=MID(text,start_num,num_chars)

Arguments of MID Function

text: It is a string or text which you want to extract
start_num: a number of character from where you want to extract.
num_char: to how many characters want in return

Behavior of MID Function

how to use mid function in excel

You have a broad data and you just want to retrieve only some characters of the column at that time this function comes to action.
Here we have taken five names. And I want character between 3 characters to  8th character of names so here I have used a MID function.
This function returns me from 3rd character to 8th character of the string.

Usage of MID Function

To get a limited character from long strings(text)

Return of MID Function

MID will return a small part of the string in between the string

How would you like this content to write us in the comment box!

If you face any difficulty in the content feel free to ask!
Thank You.



Leave a Reply

Your email address will not be published. Required fields are marked *