Forum Discussion
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 Office 365 subscriber.
Formula now shows as:
=_xlfn.CONCAT(TEXT(Week2StartDate,"MMM-DD")," - ",TEXT(Week2EndDate, "MMM-DD"))
Originally was:
=CONCAT(TEXT(Week2StartDate,"MMM-DD")," - ",TEXT(Week2EndDate, "MMM-DD"))
Removing the "_xlfn." throws a "#NAME?" error as does just clicking enter in the cell without making any changes, but replacing with CONCATENATE works. The original works just fine in the web view.
Why is CONCAT not working in the latest version of Excel??
15 Replies
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.
SergeiBaklanMy install was done from the cloud, as was my previous version. It is the 365 thick client.
