How do the TEXTBEFORE and TEXTAFTER functions in Excel ... Text Strings”. The TEXTBEFORE function pulls what comes before a delimiter. The syntax for the TEXTBEFORE function is = TEXTBEFORE(text, ...