MID, MIDB in other languages:



privacy

The Excel function: MID, MIDB

Description

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.

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   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:

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



MID, MIDB