LEFT
Description
Returns the leftmost characters from a string, based on the specified text and number of characters.
Syntax
LEFT(
text
, [
num_chars
])
- text: The text to return characters from.
- num_chars: The number of characters to return. The default is 1.
Example
Formula | Result |
|---|---|
=LEFT(A1,8)
Where cell A1 contains
Regional Sales Manager
.
| Regional |