LEFT
Definition
Returns a substring from the beginning of a specified string.
Sample Usage
LEFT(A2,2)
LEFT("lorem ipsum")
Syntax
LEFT(string, [number_of_characters])
string- The string from which the left portion will be returned.number_of_characters- [ OPTIONAL -1by default ] - The number of characters to return from the left side ofstring.
Notes
0is a valid input fornumber_of_charactersand will causeLEFTto return the empty string.
See Also
SUBSTITUTE: Replaces existing text with new text in a string.
SPLIT: Divides text around a specified character or string, and puts each fragment into a separate cell in the row.
RIGHT: Returns a substring from the end of a specified string.
MID: Returns a segment of a string.
In order to use the LEFT formula, start with your edited Excellentable:
Then type in the LEFT formula in the area you would like to display the outcome:
By adding the values you would like to calculate the LEFT formula for, Excellentable will generate the outcome:
A
|
B
|
|
|---|---|---|
1
|
||
2
|
||
3
|
||
4
|
||
5
|