Question: what is the difference between concatenate and &?
Answer: The only essential difference between CONCATENATE and "&" operator is the 255 strings limit of the Excel CONCATENATE function and no such limitations when using the ampersand. ... Some users find CONCATENATE formulas easier to read, I personally prefer using the "&" method.