Whether you are asking about to add the cell contents OR Column?
If you want to combine multiple cell values then use this formula
A Column
20
60
Cat
89
Bat
The below formula will combine the A1 to A5 cell values
=A1&A2&A3&A4&A5
=CONCATENATE(A1,A2,A3,A4,A5)
The result will be like this:-
2060Cat89Bat
If you want to give space in between the cell values then use this formula
=A1&" "&A2&" "&A3&" "&A4&" "&A5
=CONCATENATE(A1," ",A2," ",A3," ",A4," ",A5)
Both the formula’s will result the below values
20 60 Cat 89 Bat
Change the cell reference to your desired cell.
If this post helps, Click Yes!
