How do I use MID in Excel?
Use MID when you want to extract text from the middle of a string. Enter Text, Start position, Number of characters in that order, then add optional arguments when needed.
Excel Function
MID
Returns characters from middle of text.
MID(text, start_num, num_chars)Arguments
text
RequiredEnter a text value (wrap with quotes when needed).
start_num
RequiredEnter a numeric value.
num_chars
RequiredEnter a numeric value.
Practice Preview
Use MID to return the result with these settings (Text: B2 (cell B2 (Name in column B)), Start position: 2, Number of characters: 4).
Example Table
| # | AEmployee ID | BName | CEmail | DPayment Amount | EAmount Text |
|---|---|---|---|---|---|
| 2 | E001 | Taro Tanaka | t.tanaka@example.com | 1200 | 1200 |
| 3 | E002 | Hanako Suzuki | h.suzuki@example.com | 980 | 980 |
| 4 | E003 | Ken Sato | k.sato@example.com | 2450 | 2450 |
| 5 | E004 | Aya Takahashi | a.takahashi@example.com | 3000 | 3000 |
| 6 | |||||
| 7 | |||||
| 8 |
How to Use (Formula)
=MID(B2, 2, 4)Result
aro
Practice This Function
MID FAQ
Where can I practice MID?
Use the "Start Function Practice" button to jump straight into MID drills.
What arguments does MID use?
The main arguments are Text, Start position, Number of characters. Enter them in order.