Forum Discussion

rdwyer's avatar
rdwyer
Copper Contributor
Apr 03, 2019

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...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 06, 2019

rdwyer , may you share info about your Excel version as screenshort like here?

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 08, 2019

    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?

    • rdwyer's avatar
      rdwyer
      Copper Contributor
      Apr 08, 2019

      SergeiBaklan checked my original file - seems to be working fine now.

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 08, 2019

        rdwyer , have no idea what it was. Anyway, so far so good.

    • rdwyer's avatar
      rdwyer
      Copper Contributor
      Apr 08, 2019

      SergeiBaklan now that's VERY weird - I do not: