How to use the MID Function (WS, VBA)
Description
The Microsoft Excel MID function extracts a substring from a string (starting at any position).The MID function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) and a VBA function (VBA) in Excel. As a worksheet function, the MID function can be entered as part of a formula in a cell of a worksheet. As a VBA function, you can use this function in macro code that is entered through the Microsoft Visual Basic Editor.
Syntax
The syntax for the MID function in Microsoft Excel is:MID( text, start_position, number_of_characters )
Parameters or Arguments
- text
- The string that you wish to extract from.
- start_position
- The position in the string that you will begin extracting from. The first position in the string is 1.
- number_of_characters
- The number of characters that you wish to extract.
Returns
The MID function returns a string/text value.Applies To
- Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- Worksheet function (WS)
- VBA function (VBA)
Example (as Worksheet Function)
Let's look at some Excel MID function examples and explore how to use the MID function as a worksheet function in Microsoft Excel:Based on the Excel spreadsheet above, the following MID examples would return:
=MID(A1, 5, 4)
Result: "abet"
=MID(A2, 7, 3)
Result: "The"
=MID("Excel", 1, 2)
Result: "Ex"
=MID("Techonthenet.com", 5, 6)
Result: "onthen"
More Worksheet Examples
Here are more examples that show how to use the MID function as a worksheet function in Excel:Example (as VBA Function)
Dim LResult As String
LResult = Mid("Alphabet", 5, 2)
ليست هناك تعليقات:
إرسال تعليق