For quite a while now I’ve not used the CONCATENATE function as you can achieve the same results by simply using the ampersand symbol.
=CONCATENATE(A1,A2) could be replaced with
In the olden days, CONCATENATE only allowed you to join 30 items so you would have had to use the ‘&’ solution. This has now been increased to 255 items!
The biggest reason for not using CONCATENATE is that it takes longer to write and every second counts when making spreadsheets right?
The most annoying thing about CONCATENATE is that some people pronounce it CONCANTENATE. This is very wrong and those people need to be punished :-)