Also applies to:
LEFTB
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. This function is for use with double-byte characters.
Syntax
LEFT(text,num_chars)
LEFTB(text,num_bytes)
Text is the text string that contains the characters you want to extract.
Num_chars specifies the number of characters you want LEFT to extract.
Num_chars must be greater than or equal to zero.
If num_chars is greater than the length of text, LEFT returns all of text.
If num_chars is omitted, it is assumed to be 1.
Num_bytes specifies the number of characters you want LEFTB to extract, based on bytes.
Example (LEFT)
The example may be easier to understand if you copy it to a blank worksheet.
Selecting an example from Help
|
|
Example (LEFTB)
LEFTB("
",4) equals "
"