Textjoin not available in Home office 2021 excel for mac

New Contributor

I just upgraded to Home Office and Student 2021 for Mac.  TEXTJOIN does not appear to be included though everything I can find says it should.   Typing in =textjoin does not bring up the operator cues and when I go into formula builder it does not show up.  Am I going nutz or just miss something?

2 Replies

Hi @AZ_Broker


I would like to know the version of you mac ? are you using M1 machine ?

Have you tried uninstalling the application & tried installing it again. May be that should work for you. 


Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

I am using a Mid 2014 MBP i7 chip. I have updated to make sure OSX is updated and then uninstalled and reinstalled. The formula does not still seem to exist. Is there a library file stored elsewhere that might not be getting updated (renewed) when installing or reinstalling?