TEXTBEFORE

Returns text before a delimiter.

Excel: Not checked yet
Google Sheets: No equivalent
Returns: Text

Examples

=TEXTBEFORE("red-blue-green", "-")

Result red

Syntax

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

text: text required
delimiter: text required
instance_num: number optional defaults to 1
match_mode: number optional
match_end: number optional
if_not_found: any optional

Errors

#N/A: =TEXTBEFORE("alpha", 2)

ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.