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 03, 2019

rdwyer , _xlfn means what function is not available for your version of Excel. CONCAT is only for Excel which is part of Office365 package (other words you shall install it from the cloud). For Office 2016 Pro CONCAT is not available.

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

    SergeiBaklanMy install was done from the cloud, as was my previous version.  It is the 365 thick client.

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

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

       

Resources