Missing formulas

I'm trying to extract data between characters and many sites reference TEXTBEFORE and TEXTAFTER. when I try to instigate said formulas, the result is #NAME? I searched through the formulas in Excel ...