How To Use MID Function | Microsoft Excel
Syntax of MID Function
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
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!