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
FearDamhan's avatar
FearDamhan
Copper Contributor
Mar 22, 2024

EdwardWittke 

 

This is still effecting me now, 5 years later. Did anyone ever find out what the root cause is here?

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 22, 2024

FearDamhan 

If you see "_xlfn." that means this function is not available for your Excel platform/version. You may check where you are in File->About or similar, depends on platform.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 29, 2024

    FearDamhan 

    Yes, CONCAT shall be supported on 365 and bit earlier versions. On the other hand the only reason why _xlfn could appear that's not supported version Issue: An _xlfn. prefix is displayed in front of a formula - Microsoft Support

     

    If CONCAT doesn't work on new worksheet when you enter formula manually, I'd repair Office.

    If that's for the specific concrete file, e.g. imported from Goggle Sheets or like, when as variant you may try to re-enter formula in such file.

     

  • FearDamhan's avatar
    FearDamhan
    Copper Contributor
    Mar 23, 2024

    SergeiBaklan I’m running the latest 365 version on Mac. And in this case a CONCAT (not the legacy CONCATENATE) seems to be the offender. CONCAT being absolutely supported by the version.