MIDB Function in Excel: Syntax, Examples and Free Practice
MIDB is an Excel Text function. Like MID, but counts bytes instead of characters — for double-byte languages.
MIDB syntax
Arguments
text: The text to work withstart_num: The character position to start fromnum_bytes: How many bytes to return
When to use MIDB
MIDB is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice MIDB online, free
Open the live Excel-style spreadsheet and try MIDB yourself. No Excel install or sign-up needed to start.
Practice MIDB now →More Text functions
Frequently asked questions
What does the MIDB function do in Excel?
Like MID, but counts bytes instead of characters — for double-byte languages.
What is the syntax of MIDB in Excel?
The syntax is =MIDB(text, start_num, num_bytes). text: The text to work with; start_num: The character position to start from; num_bytes: How many bytes to return.
Where can I practice MIDB online for free?
Open the free live spreadsheet on Cellgrids and try MIDB yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts