How do the TEXTBEFORE and TEXTAFTER functions in Excel work? A. Excel’s TEXTBEFORE and TEXTAFTER functions ... The delimiter is the marker that separates out the data you want to split. The last four ...