LEFT

TextExcel 2007

The first N characters of a string.

Syntax

LEFT(text, [num_chars])

Arguments

text: The string.
num_charsoptional: How many characters from the left. Default 1.

Examples

=LEFT("BR28-2022", 4)

→ BR28

=LEFT(A2, FIND("@", A2) - 1)

→ priya — Everything before the @.

Related functions

RIGHT MID TEXTBEFORE

More Text functions

ARRAYTOTEXT ASC BAHTTEXT CHAR CLEAN CODE CONCAT CONCATENATE DBCS DOLLAR EXACT FIND

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.