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.

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.

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) 本=熊本

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.