Just as a point of interest as there have been a few posts on Concatenate recently. I tend to use "&" rather than the concatenate formula. eg:
I haven't come across any issues using it and it seems to work in the same way as CONCATENATE. The only possible issue I can see is other users not being able to understand the formula.
Does anyone have any thought?