TextJoin function not working in 2016

Hi,

I used TextJoint function in a macro, it works for me but my client says it is not working for him.

I tested on Windows 10 PC with Office 365.

Please Login or Register  to view this content.

Here is the client email
-----------------------------
It worked for Spencer on his Mac (office 365, v16), but not for Dakota or I on our personal machines.
Win10, Office 2019
Win11, Office 2016
-----------------------------

Can I use CONCAT function instead of TextJoint?

Please help me on this issue.

Here is the complete set of code

Please Login or Register  to view this content.

Textjoin function is only supported in office 365 and Excel 2019 (and up)
see "subtitle" of this article https://support.microsoft.com/en-us/...3-0e8fc845691c

you need to use the old "concat" funtion where textjoin is now,

you can also use the VBA Join command and then only write the outcome to the cells that now have the textjoin function.

Thank you so much for your replies. I will use the below function instead of TextJoin. I will let you know guys if my client comes back again.

Please Login or Register  to view this content.

Thank you Roel Jongman. I will use CONCATENATE function and let us see what happens.

Yes, I specified individually. Thanks Rorya.