The LEFT function
Returns the characters from the left of a text string, given a length.
=LEFT("AnyString", 7) return "AnyStri"
- text - Required. String expression from which the leftmost characters are returned.
- num_char - Required. Numeric expression indicating how many characters to return.