LEFT function
LEFT(Text,
Length?) LEFT(Text;
Length?)
Text
Text or { Text }
The string from which to extract a part.
Length
Number or { Number } (optional)
The number of characters to include. If omitted, 1 is assumed, meaning that only the first character of the text string is returned.
Returns
Text or { Text }
Text from the left side of the given text string.
Returns text from the left side of a text string.
Examples
LEFT("abcd")LEFT("abcd")
Returns "a", the first character of "abcd".
LEFT("abcd",
2)LEFT("abcd"; 2)
Returns "ab", the first two characters of "abcd".