LEFTB
Returns the first characters of a DBCS text.
LEFTB("Text" [; Number_bytes])
Text āĻšāĻ˛ā§ āĻāĻāĻāĻŋ āĻā§āĻā§āĻ¸āĻ, āĻ¯ā§āĻāĻžāĻ¨ āĻĨā§āĻā§ āĻĒā§āĻ°āĻžāĻ°āĻŽā§āĻāĻŋāĻ āĻāĻāĻļāĻŋāĻ āĻļāĻŦā§āĻĻ āĻ¨āĻŋāĻ°ā§āĻ§āĻžāĻ°āĻŖ āĻāĻ°ā§āĨ¤
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).