Forum Discussion
Missing CONCATENATE
Why does Excel no longer have CONCATENATE function listed under text functions in the Insert Function dialogue box? The CONCAT function is there but not the CONCATENATE. Note, you still have the abil...
Since CONCATENATE is a legacy function that has been superseded by CONCAT and TEXTJOIN, it is not listed under the Text category, but under the Compatibility category (and under All, of course)