Question

in excel, what do you mean by concatenation, which character is used for the concatenation​

Answer 1

Answer:

=CONCATENATE(B2, " ", C2) Joins three things: the string in cell B2, a space character, and the value in cell C2. The result is Andreas Hauser. =CONCATENATE(C2, ", ", B2) Joins three things: the string in cell C2, a string with a comma and a space character, and the value in cell B2.