2.1.992 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.