How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER functions ... The syntax for the TEXTBEFORE function is = TEXTBEFORE(text, delimiter, [instance_num], ...