Forum Discussion
why doesn't Excel recognize the TEXTBEFORE() and TEXTAFTER() functions when I try to use them?
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
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)
SergeiBaklan thanks Sergie. Yes, my work laptop has 2202 (semi annual) and this function isn't available. but my personal laptop has version 2210 and its working 🙂
Check which channel do you have on laptop, with 2210 that's most probably Current channel. Functions shall be available on this channel. With semi-annual you have to wait, perhaps till next spring. All depends on your subscription channel.
- I can confirm it's available in Current channel. I run Current Channel (version 2210) on two devices at work and those functions have been available for several weeks at least.
- It appears to have been removed. It was there yesterday, but now the formula I created is broken and it doesn't show up in the list of functions. Such nonsense.
