How do the TEXTBEFORE and TEXTAFTER functions in Excel work ... the TEXTAFTER function instead of the TEXTBEFORE function. See the screenshot below. In the next example, I would like to eliminate the ...