Formula
Description
=LEFT(text,num_chars)
Extracts a specified number of characters from the beginning of a text string.
=LEFTB(text,num_chars)
Extracts a specified number of bytes from the beginning of a text string.
=LEFTC(text,num_chars)
Extracts a specified number of characters from the beginning of a text string, taking into account double-byte characters.
=LEFTPAD(text,length,character)
Pads a text string with a specified character to a specified length by adding characters to the beginning.
=LEFTTRIM(text)
Removes any leading spaces or other specified characters from a text string.
=LEFTWORDS(text,num_words)
Extracts a specified number of words from the beginning of a text string.