Left

Description of formula:
Returns a specified number of characters from the beginning of a text. If the number of characters is greater than the length of a text, formula returns whole text.
Syntax:
left(text, length)
Parameters:
text
(type: Text) Text that contains characters to extract
length
(type: Number) Number of characters you want to extract. Must be greater than or equal to 0.
Returned type:
Text
Examples:
=left('one two three', 3)
=left(section1.A1, 3)
=left('one two three', A1)
Remarks:
Spaces counts as characters.
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk