← Back to level 1
Level 1Next
MID
A easy text formula for pulling characters from the middle of a string.
Syntax
=MID(...)Step-by-step explanation
- 1Pick the text cells or values that need to be combined or reformatted.
- 2Use the formula to extract, join, or format the text in the way you need.
- 3Press Enter and read the output as a cleaned-up label or string.
Common mistakes
Starting from the wrong character position
Using the wrong length argument
Forgetting that positions start at 1
Example table
A quick scenario to connect the syntax to the result.
| 12 | 18 |
| 8 | 42 |
Formula
=MID(A1:B2)
Result
42
Worked example
- 1Inspect the source text in the sample table and decide what should change.
- 2Enter =MID(A1:B2) to format, join, or extract the text.
- 3The final text result should read 42.
Practice area
Use MID when the part you need starts inside the text instead of at the beginning or end.
Match against the syntax block above.