Forum Discussion

peyjmonahmad's avatar
peyjmonahmad
Copper Contributor
Jan 20, 2022

TEXTJOIN function not available anymore

Hi, I used the TEXTJOIN function pretty frequently in excel, but I do not see the availability of the function anymore.

 

When I try to type in the function, it does not come up.  I am not able to locate it.  The only function I see that comes up is the TEXT function, not TEXTJOIN.

 

Please assist. I have on a Mac Version 10.15.7 and Excel Version 16.56

 

Formulas and Functions

2 Replies

Sort By
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jan 22, 2022

    peyjmonahmad 

    First of all, please check whether the result cell is formatted as text.

    If this occurs in the whole sheet, make sure that the formula display is activated.

     

    I'm not a Mac user, but that doesn't prevent me from sending you an alternative.

    If your Excel TEXTJOIN function is not working but you need to use it urgently, in this case you can use the alternative option like CONCAT function.

     

    This function offers you the same functions as CONCATENATE. It is enabled to minimize the length of the function name and its arguments.

     

    However, the CONCAT function replaces CONCATENATE. It is available in all current Excel versions to ensure compatibility with previous versions. This option is also available on Mac as far as I know.

     

    Hope I was able to help you with this information’s/links.

     

    Thank you for your understanding and patience

     

    NikolinoDE

    I know I don't know anything (Socrates)

     

Resources