How do the TEXTBEFORE ... TEXTSPLIT to Dissect Excel Text Strings”. The TEXTBEFORE function pulls what comes before a delimiter. The syntax for the TEXTBEFORE function is = TEXTBEFORE(text, delimiter, ...