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...
Thanks, I know that I can mannually type which how I normally input it. I was wondering if there was a reason it was not on the Insert Function dialogue box.
Note: I probably would not have even noticed it was missing, but I was teach my son Excel and I've referred him to the Insert Function dialogue box to find a function not expecting it not to be there.
Microsoft introduces new function CONCAT() instead of CONCATENATE(). So, teach your son CONCAT().
Note: the concat function does not yield the same result as the concatenate function in all circumstances. Here's just one example of a difference, I have seen at least one other instance where the CONCATE yielded a different result thatn the CONCATENATE, but I don't recall what that was,