MID Function returns a specific number of characters from a text string at the specified starting position and specified number of characters.
In other words, MID Function is used to extract text from inside a text string, based on location and length.
The MID Function is an inbuilt function in Excel. It is categorized as a String/Text Function.
You can use this function as both, a worksheet function and VBA Function. You can enter MID function as part of a formula in a cell of a worksheet.
As a VBA function, it is used in macro code that is entered through the Microsoft Visual Basic Editor.
Syntax for MID Function
=MID(text, start_num, num_chars)
Arguments
Text: The text string containing the characters you want to extract or the cell reference.
Start_num: The position of the first character you want to extract in the text string. The first character in the text string has start_num 1, and so on.
Num_chars: Specifies the number of characters you want MID to extract from the text string.
I have created the infographics for the MID Function. With the help of these infographics, you can easily learn step by step process for using this excel functions.
Furthermore, Excel consists of many inbuilt functions which are helpful in the analytical and statistical study of number.
Simply follow the instructions in the infographics below:
Start_num should not be greater than the length of the text string, otherwise, MID Function will return an empty cell.
If start_num is < 1, the MID returns the #VALUE! error value.
If num_chars is a negative value, the MID returns the #VALUE! error value.
To learn other function like FLOOR, BASE, and DATE Functions, please click on the name of the function.
Additionally, you can download other accounting templates like Break Even Analysis Template, Sales Revenue Analysis Template and Invoice with GST Template from here.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.
Leave a Reply