TEXTBEFORE and TEXTAFTER Easily extract specific data from Excel using the new TEXTBEFORE and TEXTAFTER functions. These functions simplify the way to extract text.