FUNCTION CATALOGUE / TEXT
TEXTBEFORE Excel function
Returns text before a delimiter.
Correct sentence to use
Return the text before [delimiter] in [text].
Modify this query in PlainFormula →Example formula
=TEXTBEFORE(A2,"-")
Returns text before a delimiter.
Syntax
TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])
Argument signature: text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found]
Availability note
Available in supported Microsoft 365 / newer Excel versions; verify the exact release and platform.