2.1.989 Part 1 Section 18.17.7.210, MID

a.   The standard states that 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).

In Office, MID is intended for use with any language, whereas MIDB is intended for use with languages that use the double-byte character set (DBCS).

b.   The standard states if start-pos < 0, #VALUE! is returned.

Office returns #VALUE! if start-pos < 1.

c.   The standard states that if the start-pos argument is greater than the length of string, or if start-pos and number- bytes combined exceeds the length of the string argument, the whole of the string argument shall be extracted.

In Office, if start-pos is greater than the length of string the empty string is returned. If start-pos and number-bytes combined exceeds the length of string, the remainder of string starting at byte position start-pos is returned.

Show: