Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

LEFT

Description: Returns the first character or characters in a text string.

Syntax: LEFT(Text, [Num_char])

• Text is the text string that contains the characters you want to extract.

• Num_char specifies the number of characters you want LEFT to extract.

Remarks:

• Num_char must be greater than or equal to 0.

• If Num_char is greater than the length of text, LEFT returns all of text.

• If Num_char is omitted, it is assumed to be 1.

Example:

• LEFT("Sale Price", 4) = "Sale" [the first four characters in the first string]

• If A1 contains "Sweden", then:

LEFT(A1) = "S"