MIDB function

The MIDB function returns a section of a string starting at a given character and up to a specified number of bytes.

Parts of a MIDB function

MIDB(string, starting_at, extract_length_bytes)

Part	Description
string	The string from which to extract a section.
starting_at	The position in the input `string` to start extracting from.
extract_length_bytes	The number of bytes the extracted string should have.

Notes

• MIDB returns the same value as MID if the input string has only single byte characters
• Starting_at must be greater than or equal to 1.
• Extract_length_bytes must be greater than or equal to 0.

Examples

	A	B	C
1	Input	Formula	Output
2	Aeñds	=MIDB(A2, 2, 2)	eñ
3	Aeñds	=MID(A3, 2, 2)	eñ
4	熊本=熊本	=MIDB(A4,2,4)	本=熊
5	熊本=熊本	=MID(A5,2,4)	本=熊本

Related functions

• LENB : The LENB function returns the length of a string in bytes.
• LEFTB : The LEFTB function returns the left portion of a string up to a certain number of bytes.
• RIGHTB : The RIGHTB function returns the right portion of a string up to a certain number of bytes.