"Sloth" wrote in message
...
CONCATENATE means to join multiple strings together to form one long
string.

Example:
A1 John
A2 Smith
A3 =CONCATENATE(A2,", ",A2)

A3 equals "Smith, John" which is the combination of three text strings
"Smith", ", " and "John".

It is better to use & to join text strings

Why is that method better?