Forum Discussion
nateajj
Nov 25, 2024Copper Contributor
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...
HansVogelaar
Nov 25, 2024MVP
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)