Forum Discussion
rdwyer
Apr 03, 2019Copper Contributor
Concat function not woking in Excel version 1903
I just installed Excel version 1903 (had previously been on 1901 or 1902) and I came across "_xlfn." preceding my CONCAT functions in a worksheet. I use the thick client (Professional) but am an Off...
rdwyer
Apr 08, 2019Copper Contributor
SergeiBaklan
Apr 08, 2019Diamond Contributor
rdwyer , that's strange, the function is definitely supported by monthly channel Excel version. If you open attached file in this your version do you see the same error?
- rdwyerApr 08, 2019Copper Contributor
SergeiBaklan checked my original file - seems to be working fine now.
- SergeiBaklanApr 08, 2019Diamond Contributor
rdwyer , have no idea what it was. Anyway, so far so good.
- EdwardWittkeMay 02, 2019Copper Contributor
SergeiBaklan I encountered this myself when moving to Windows 10 1809. I get the "_xlfn." for IFS() when I double-click on the excel file from File Explorer. But the file will load properly if I open Excel and then open the XLSX file from within Excel with the proper IFS()
- rdwyerApr 08, 2019Copper Contributor