Returns a substring from the beginning of a specified string.
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 of
0is a valid input for
number_of_charactersand will cause
LEFTto return the empty string.
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.
Mary is a Docs & Drive expert and author of this help page. Leave her feedback below about the page.