TEXTBEFORE function in Excel

TEXTBEFORE returns text before a delimiter.

Syntax

=TEXTBEFORE(text, delimiter, [instance_num])

Argument	Required?	What it is
text	Required	The text or cell to work with.
delimiter	Required	The text to split on or to put between items, such as ", " or "-".
instance_num	Optional	Which occurrence to use (1 for the first). Negative numbers count from the end.

=TEXTBEFORE("ana@mail.com","@") returns ana. =TEXTAFTER("a/b/c.xlsx","/",-1) returns c.xlsx.

Forgetting these need a recent Excel version (Microsoft 365 or Excel 2024). In Excel 2021 and earlier they show #NAME?, so use LEFT/MID with FIND there.
Expecting a match when the delimiter is not in the text: you get #N/A.

Type the formula yourself and get it graded instantly, no Excel needed.

TEXTBEFORE returns text before a delimiter.

=TEXTBEFORE(text, delimiter, [instance_num])

Argument	Required?	What it is
text	Required	The text or cell to work with.
delimiter	Required	The text to split on or to put between items, such as ", " or "-".
instance_num	Optional	Which occurrence to use (1 for the first). Negative numbers count from the end.

=TEXTBEFORE("ana@mail.com","@") returns ana. =TEXTAFTER("a/b/c.xlsx","/",-1) returns c.xlsx.

Forgetting these need a recent Excel version (Microsoft 365 or Excel 2024). In Excel 2021 and earlier they show #NAME?, so use LEFT/MID with FIND there.
Expecting a match when the delimiter is not in the text: you get #N/A.

Type the formula yourself and get it graded instantly, no Excel needed.