How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER ... The text argument references the text or cell where you’re searching. The delimiter is the marker ...