Question 1 of 10
The first argument is the original string of text, the second argument is the number of the character at which you want to start extracting text, and the third argument is the number of characters you want to extract.
For example, =MID("Hello", 2, 3) returns three characters from the string "Hello" starting at character #2. What would the formula return?
| A | B | C | D | |
|---|---|---|---|---|
| 1 | ||||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 |
MID Function - Free Excel Practice Online
This free, interactive exercise teaches you MID Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Text Search Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising MID Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this MID Function lesson
- The MID function in Excel returns text from the middle of another string of text, the way LEFT and RIGHT return the left-most and right-most characters from a string of text. The first argument is the original string of text, the second argument is the number of the character at which you want to start extracting text, and the third argument is the number of characters you want to extract.For example, =MID("Hello", 2, 3) returns three characters from the string "Hello" starting at character #2. What would the formula return?
- =MID(A3, 2, 3) returns three characters from the string in cell A3 starting at character #2. What would the formula return?
- What would =MID(B5, 4, 2) return?
- What would =MID(A5, 1, 5) return?
- Write a MID formula that would return "pin" using the cell references in the table below.
- Write a MID formula that would return "lery" using the cell references in the table below.
- Write a MID formula that would return "South" using the cell reference A1.
- Write a MID formula that would return "South" using the cell reference A6.
- Write a MID formula that would return "land" using the cell references available below.
- Write a MID formula that would return "man" using the cell references available below.
MID Function practice - FAQ
How do I practice MID Function in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the MID Function exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this MID Function lesson?
This lesson covers MID Function as part of the Text Search Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.