Forum Discussion
Missing CONCATENATE
Instead try manually typing it.
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,
