TEXTBEFORE and TEXTAFTER The new functions TEXTBEFORE and TEXTAFTER allow you to extract subtext easily on a delimiter.