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...
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,