How can I add all of the text strings in all of the cells in a row together?
Solution 1:
Another solution is to use the CONCATENATE() function.
See the knowledge base for further details.
Examples
If cell A1 contains Lorem and cell B1 contains Ipsum, =CONCATENATE(B1, “, “, A1) returns “Ipsum, Lorem”.
=CONCATENATE(60, 60) returns “6060”.
=CONCATENATE(“a”, “b”, “c”) returns “abc”.
=”a”&”b”&”c” also returns “abc”, because the ampersand is the concatenation operator.
To add to every row, just drag the formula handle to copy the formula down.
