I just wondered if one method had more options available than the other. I
suppose using CONCATENATE() might make for more easily readable formulae, if
they need to be understandable to someone who didn't create the sheet.

"Sloth" wrote in message
...
In my opinion...

it is more efficient (11 less charectors to type)
it is simple to type (you can't mispel it)
it is easier to understand (to me anyway)

although I geuss it is up to debate which method is better, and I should
have said "You can also use the ampersand (&) to join strings together."
instead.

"Doug Kanter" wrote:

"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?