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?
3 Replies
- SergeiBaklanDiamond Contributor
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.
- yarenscCopper Contributor
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?
- PeterBartholomew1Silver Contributor
Maybe you imported or set the file up using a web version of Excel rather than your desktop licenced version?