Skip to content

TEXTBEFORE

TextMicrosoft 365

The text that comes before a given delimiter.

Syntax

TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])

Examples

=TEXTBEFORE("[email protected]", "@")

→ priya

=TEXTBEFORE(A2, " ", -1)

→ all but the last word — Negative counts from the end.

Related functions

TEXTAFTERTEXTSPLITLEFT

More Text functions

ARRAYTOTEXTASCBAHTTEXTCHARCLEANCODECONCATCONCATENATEDBCSDOLLAREXACTFIND

← 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.