MIDB

MIDB the characters following the first start_pos bytes comprising at most num_bytes bytes

Synopsis

MIDB(s,start_pos,num_bytes)

Arguments

s: the string

start_pos: the number of the byte with which to start (defaults to 1)

num_bytes: the maximum number of bytes to return (defaults to 1)

Note

The semantics of this function is subject to change as various applications implement it.

Microsoft Excel Compatibility

While this function is syntactically Excel compatible, the differences in the underlying text encoding will usually yield different results.

OpenDocument Format (ODF) Compatibility

While this function is OpenFormula compatible, most of its behavior is, at this time, implementation specific.

See also

LEFTB, RIGHTB, LENB, LEFT, MID, RIGHT, LEN.