LEFT, LEFTB in other languages:



privacy

The Excel function: LEFT, LEFTB

Description

LEFT returns the first character or characters in a text string, based on the number of characters you specify.

LEFTB returns the first character or characters in a text string, based on the number of bytes you specify.

 Important   LEFTB counts 2 bytes per character only when a DBCS language is set as the default language. Otherwise LEFTB behaves the same as LEFT, counting 1 byte per character.

The languages that support DBCS include Japanese, Chinese (Simplified), Chinese (Traditional), and Korean.



LEFT, LEFTB