LEFTB
Returns the first characters of a DBCS text.
LEFTB("Text" [; Number_bytes])
α’αα₯α‘α’α αα αα‘ α’αα₯α‘α’α α‘ααααͺ α‘αα’α§ααααα‘ ααα¬ααααα α£ααα ααααα‘ααα¦αα αα‘.
Number_bytes (optional) specifies the number of characters you want LEFTB to extract, based on bytes. If this parameter is not defined, one character is returned.
=LEFTB("δΈε½";1) returns " " (1 byte is only half a DBCS character and a space character is returned instead).
=LEFTB("δΈε½";2) returns "δΈ" (2 bytes constitute one complete DBCS character).
=LEFTB("δΈε½";3) returns "δΈ " (3 bytes constitute one DBCS character and a half; the last character returned is therefore a space character).
=LEFTB("δΈε½";4) returns "δΈε½" (4 bytes constitute two complete DBCS characters).
=LEFTB("office";3) returns "off" (3 non-DBCS characters each consisting of 1 byte).