LEFT
Returns the specified number of characters from the start of a text string
Syntax
LEFT(text, [num_chars])
Parameters
- text: Required. The text string that contains the characters you want to extract
- num_chars: Optional. The number of characters to extract (default 1)
Example
=LEFT("Sale Price", 4)