In this article
MIDB is the byte-based version of MID; identical to MID in English setups.
Advertisement
Syntax
=MIDB(text,2,3)| Argument | What it means |
|---|---|
text |
Text to work on |
Examples
Example 1
=MIDB(A2,2,3)Result: umb. See the worked example table below for more cases.
MIDB in practice
Where you will use it
- Japanese, Chinese or Korean data
- Fixed-width files measured in bytes
- Cleaning full-width characters from imported forms
Worked example
| Text | Formula | Result |
|---|---|---|
| Mumbai | =MIDB(A2,2,3) | umb |
| Excel | =MIDB(A3,2,3) | xce |
| 12345 | =MIDB(A4,2,3) | 234 |
Results calculated in Excel. Calculated on an English (single-byte) Excel.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Expecting different results in English | In single-byte setups the B versions match LEFT, LEN, etc. |
| Mixed-width data | Normalise with ASC first |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong