LEFT

See also A-Z Spreadsheet Function List

Description Returns the leftmost characters from the specified text string.

Syntax LEFT(text [, num_chars])

text is any text string.

num_chars is the number of characters to return. This value must be greater than or equal to zero. If num_chars is greater than the number of characters in text, the entire string is returned. Omitting this argument assumes a value of 1.

See Also MID and RIGHT functions

Examples LEFT(“2nd Quarter”) returns “2”

         LEFT(“2nd Quarter”, 3) returns “2nd”