Excel > Function References > Text Functions

MIDB function

For double-byte character set (DBCS) languages, returns a specific number of characters from a text string, starting at the position you specify, based on the number of bytes you specify.

This function is an East Asian language-specific feature. To use this function, you must turn on Chinese language features or turn on Japanese language features in Excel.

Syntax

MIDB(text,start_num,num_bytes)

Argument	Description	Remarks
text	The text string that contains the characters that you want to return.	None.
start_num	The position of the first character that you want to extract in text. The first character in text has start_num 1, and so on.	If this argument is greater than the length of text, this function returns "" (empty text). If this argument is less than 1, this function returns the #VALUE! error value.
num_bytes	Specifies the number of characters you want MIDB to return from text, in bytes.	If this argument is negative, this function returns the #VALUE! error value.

Example

=MIDB(" Japanese Character 1 Japanese Character 2 Japanese Character 3 Japanese Character 4 Japanese Character 5 Japanese Character 6 ",1,6), equals " "

See also
CODE function
FINDB function
LEFTB function
MID function
RIGHTB function
SEARCHB function
List of all functions (by category)

Share your feedback about this topic

Rate this content: