donnawomanCopper ContributorJul 09, 2021why doesn't Excel recognize the TEXTBEFORE() and TEXTAFTER() functions when I try to use them? When I attempt to use these functions, Excel returns the #NAME? error message.