How can I add all of the text strings in all of the cells in a row together?
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”&amp;”b”&amp;”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.