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 ...
Formulas and Functions
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