Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • What-If Analysis: Scenarios and Goal Seek in Excel
  • How To Create Frequency Distribution in Excel
  • How to sum a total in multiple Excel tables
  • How to Create One and Two Variable Data Tables in Excel
  • Create Scatter Chart in Excel

References

  • How to use Excel LOOKUP Function
  • How to use Excel ROW Function
  • How to get address of named range in Excel
  • Offset in Excel
  • How to get address of first cell in range in Excel

Data Validations

  • Excel Data validation number multiple 100
  • Excel Data validation whole percentage only
  • Excel Data validation must begin with
  • Excel Data validation unique values only
  • Excel Data validation date in next 30 days

MID, MIDB functions: Description, Usage, Syntax, Examples and Explanation

by

What are MID, MIDB functions in Excel?

MID, MIDB functions are  TEXT functions in Microsoft Excel.

MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.

While, 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.

Important:

  • These functions may not be available in all languages.
  • MID is intended for use with languages that use the single-byte character set (SBCS), whereas MIDB is intended for use with languages that use the double-byte character set (DBCS). The default language setting on your computer affects the return value in the following way:
  • MID always counts each character, whether single-byte or double-byte, as 1, no matter what the default language setting is.
  • MIDB counts each double-byte character as 2 when you have enabled the editing of a language that supports DBCS and then set it as the default language. Otherwise, MIDB counts each character as 1.

The languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.

Syntax of MID, MIDB functions

MID(text, start_num, num_chars)

MIDB(text, start_num, num_bytes)

The MID and MIDB function syntax has the following arguments:

  • Text: The text string containing the characters you want to extract.
  • Start_num: The position of the first character you want to extract in text. The first character in text has start_num 1, and so on.
  • Num_chars: Specifies the number of characters you want MID to return from text.
  • Num_bytes: Specifies the number of characters you want MIDB to return from text, in bytes.

MID, MIDB formulas explanation

  • If start_num is greater than the length of text, MID returns “” (empty text).
  • If start_num is less than the length of text, but start_num plus num_chars exceeds the length of text, MID returns the characters up to the end of text.
  • If start_num is less than 1, MID returns the #VALUE! error value.
  • If num_chars is negative, MID returns the #VALUE! error value.
  • If num_bytes is negative, MIDB returns the #VALUE! error value.

Example of MID, MIDB functions

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Data
Fluid Flow
Formula Description Result
=MID(A2,1,5) Returns 5 characters from the string in A2, starting at the 1st character. Fluid
=MID(A2,7,20) Returns 20 characters from the string in A2, starting at the 7th character. Because the number of characters to return (20) is greater than the length of the string (10), all characters, beginning with the 7th, are returned. No empty characters (spaces) are added to the end. Flow
=MID(A2,20,5) Because the starting point is greater than the length (10) of the string, empty text is returned.

Post navigation

Previous Post:

MODE.MULT function: Description, Usage, Syntax, Examples and Explanation

Next Post:

231 Keyboard Shortcut Keys In Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Extract multiple matches into separate rows in Excel
  • How to use Excel AND Function
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • Invoice status with nested if in Excel
  • NOT function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • DATEDIF function: Description, Usage, Syntax, Examples and Explanation
  • How to get Holiday Date from Year in Excel
  • How to get same date next month or previous month in Excel
  • Display Days in month in Excel
  • Get project end date in Excel

Grouping

  • Group arbitrary text values in Excel
  • Calculate conditional mode with criteria in Excel
  • Group numbers with VLOOKUP in Excel
  • Group times into 3 hour buckets in Excel
  • Group numbers at uneven intervals in Excel

General

  • How to make excel worksheets print on one page?
  • How to calculate percentage of total in Excel
  • How to calculate percent of students absent in Excel
  • Split Cell Content Using Text to Columns in Excel
  • Convert column letter to number in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning