Forum Discussion
Excel TEXTBEFORE function went away and gives #NAME? error
Hi all,
I had an Excel sheet working using Office 2019 on a Windows 11 machine using the TEXTBEFORE function. Now after the latest Windows update, the function seems to have disappeared from excel? I now see #NAME? errors, and its not an option for selecting when adding a new function to a cell. The functions were also auto-replaced with a new prefix:
```
=_xlfn.TEXTBEFORE(L241, " ")
```
I'm on Excel Version 2410
Tried to add the build number, but I get an error on publishing saying "##.#.#### is not allowed in the community"
Anybody else seen this or have any ideas on what's happening?
TEXTBEFORE() is not available for Office 2019. It could, could not, show result if the file was created in later version of Office. Till you re-enter the formula.
In general _xlfn means that function is not available.
I created the formula on this computer in this file a week ago, and now it stopped working after a restart? Is there some way it would have initially worked?
Maybe you imported or set the file up using a web version of Excel rather than your desktop licenced version?
