---
title: "MID, MIDB functions in Excel"  
description: "In this article I have described about the MID and MIDB function in Microsoft Excel."  
author: "AVADHESH PATEL"  
published: 2013-03-28  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1173/mid-midb-functions-in-excel  
category: "excel"  
tags: ["excel"]  
reading_time: 1 minute  

---

# MID, MIDB functions in Excel

In this [article](https://yourviews.mindstick.com/view/81489/kashmir-now-after-an-year-of-abrogation-of-article-370) I have described about the MID and MIDB [function](https://www.mindstick.com/articles/43970/purchase-suitable-wedding-dresses-for-your-wedding-function) in [Microsoft](https://yourviews.mindstick.com/view/81711/microsoft-disconnects-cortana-and-reinvents-it) Excel.\

MID returns a specific number of [characters](https://answers.mindstick.com/qa/42112/who-is-the-originator-of-avengers-characters) from a text string, [starting](https://www.mindstick.com/blog/12024/things-you-need-to-know-when-starting-your-own-business) at the position you specify, based on the number of characters you specify. In other hand MID always counts each [character](https://www.mindstick.com/articles/23551/an-investigate-distinctive-seafood-restaurant-for-your-image-stamp-character), whether single-byte or double-byte, as 1, no matter what the default [language setting](https://answers.mindstick.com/qa/31022/how-to-change-the-language-setting-of-my-google-chrome) is.

##### Syntax

MID(text, start_num, num_chars)

MIDB returns a specific number of characters from a text string, starting at the position you specify, based on the number of bytes you specify. In other hand MIDB counts each double-byte character as 2 when you have enabled the editing of a language that [supports](https://www.mindstick.com/blog/12043/how-to-create-a-killer-mobile-app-that-supports-your-brand) DBCS (double-byte character set) and then set it [as the default](https://answers.mindstick.com/qa/109628/how-to-set-bing-as-the-default-seek-engine-in-microsoft-edge) language. Otherwise, MIDB counts each character as 1.

##### Syntax

MIDB(text, start_num, num_bytes)

![MID, MIDB functions in Excel](https://www.mindstick.com/mindstickarticle/211b5519-51d3-4153-8a56-06e50fd96136/images/9badbe1e-1217-457d-bdad-8f6255837fb7.png)

---

Original Source: https://www.mindstick.com/articles/1173/mid-midb-functions-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.