By looking at some examples below, you might be able to understand the function better.

- =MID(“The cat in the hat”,5,3)

This will return “cat”

- =MID(“The cat in the hat”,16,3)

This will return “hat”

- =MID(“apple”,3,100)

This will return “ple”

- =MID(12348,3,4)

This will return “348” as text

Some of the other MID formula examples that can be obtained include the functionalities of translating numbers to text, stripping numeric characters from cells, highlighting numbers that include symbols, abbreviating names or words, LAMBDA strip characters, splitting dimensions into three parts, parsing time strings to time, data validating specific characters only, etc.

The MID function is used as a Worksheet function (WS), as well as a VBA function (VBA). The above examples are of MID’s Worksheet functions.

As a MID’s VBA function example:

- Dim LResult As String

LResult=Mid(“Alphabet”,5,2)

This will return “ab”

The MID function applies to the following models or versions of Excel:

Excel 2000, Excel XP, Excel 2003, Excel 2007, Excel 2010, Excel 2011 for Mac, Excel 2013, Excel 2016, Excel 2019, and Excel for Office 365.