LEFT, LEFTB function
Summary
Returns the leftmost characters from a text value
Syntax
LEFT(text, [num_chars])
The function syntax has the following arguments:
• Text Required. The text string that contains the characters you want to extract.
• Num_chars Optional. 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_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.
• Text Required. The text string that contains the characters you want to extract.
• Num_chars Optional. 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_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.
Example
=LEFT(A2,4)
=LEFT(A3)
=LEFT(A3)