LEFT()

LEFT() - This function returns the first character or characters of a text.

Syntax

LEFT(text; number)

text is the text where the initial partial words are to be determined.

Number (optional) specifies the number of characters for the start text. If this parameter is not defined, one character is returned.

Example:

=LEFT("Southbound";5) returns South

=LEFT("Southbound") returns S