Forum Discussion

yarensc's avatar
yarensc
Copper Contributor
Nov 29, 2024

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?...
Excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
MVP
Nov 30, 2024

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.

  • yarensc's avatar
    yarensc
    Copper Contributor
    Nov 30, 2024

    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?

    • PeterBartholomew1's avatar
      PeterBartholomew1
      Silver Contributor
      Nov 30, 2024

      Maybe you imported or set the file up using a web version of Excel rather than your desktop licenced version?

Resources