How to use the MID function in Excel. Open Microsoft Excel. Use an existing table or create one. In the cell where you want to place the result type =MID(A3,4,2).

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.