Forum Discussion
donnawoman
Jul 10, 2021Copper Contributor
why 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.
Lorenzo
Jul 10, 2021Silver Contributor
As of today none of those functions exist, hence the #NAME? error you get
Suggest you expose what you expect to do + upload a sample with the expected result
Suggest you expose what you expect to do + upload a sample with the expected result
- Muhammad_J880Nov 23, 2022Copper Contributor
https://support.microsoft.com/en-us/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29
I also have same issue and I am using latest 365
- Muhammad_J880Nov 23, 2022Copper ContributorOh because it’s for a beta program only and not rolled out for everyone 🫣
- SergeiBaklanNov 23, 2022MVP
I didn't check, but most probably it's available at least on Current channel. "Latest Microsoft 365" means practically nothing, more important is it latest for your channel (semi-annual, current, etc), subscription (consumer, business, which one) and platform (Windows, Mac, Android, etc)