Related Topics: | ||
Description: Returns the first character or characters in a text string.
Syntax: LEFT(Text, [Num_char])
Text is the text string that contains the characters you want to extract.
Num_char specifies the number of characters you want LEFT to extract.
Remarks:
Num_char must be greater than or equal to 0.
If Num_char is greater than the length of text, LEFT returns all of text.
If Num_char is omitted, it is assumed to be 1.
Example:
LEFT("Sale Price", 4) = "Sale" [the first four characters in the first string]
If A1 contains “Sweden”, then:
LEFT(A1) = "S"
© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.