How to combine the content of two or more cells in Excel
How do you combine the text of multiple cell?
How do you merge the content of two cells?
How do you you combine the content of two columns?
To combine the text of two columns or to combine the cell of two cells into a third cell, enter = A1 & A2 into the third cell.
or use the function = CONCATENATE(A1,A2,....)
You can add other characters in the combination like = A1 & " " & A2 which inserts a space between the two words
(for formulas, depending on your country, you might have to change ; with , or the opposite