Forum Discussion

Copper Contributor

Jul 04, 2018

.xlfn when using =FORMULATEXT on excel 2016

Hello all, I’m using Microsoft excel 2016. I have used the FORMULATEXT function to show the formulas in row a as text in row b. For some reason every time I open the file a “.xlfn_” is ad...

Formulas & Functions

Copper Contributor

Jul 04, 2018

No sir Hebrew

SergeiBaklan
Diamond Contributor
Jul 04, 2018
When it shall be another name for that function for your SKU
- Gai Golan
  Copper Contributor
  Jul 04, 2018
  how can i find the other name ?
  
  when i use the FORMULATEXT it works, but when i close the file and reopen it i get the .xllfn_
  - SergeiBaklan
    Diamond Contributor
    Jul 04, 2018
    Gai,
    
    Here is the formula translator https://en.excel-translator.de/translator/ if it supports your version.
    
    Another option is to open this https://support.office.com/en-us/article/formulatext-function-0a786771-54fd-4ae2-96ee-09cda35439c8 support article (English US) and in very left bottom of the page to change the language - it will show the same article in selected language.
    
    _xlfn. is displayed when the function is not supported by your version of the Excel https://support.office.com/en-gb/article/issue-an-xlfn-prefix-is-displayed-in-front-of-a-formula-882f1ef7-68fb-4fcd-8d54-9fbb77fd5025. Since you are on Excel 2016 most probably that's the localization, i.e. in your local version the function has another name.

Resources