How can I add all of the text strings in all of the cells in a row together? I am building a tracking sheet in Numbers for when I need to send my clients lists. I can't seem to figure out how to build a text string that contains information from all of the cells in one row.

I have columns that contain the subject's name, whether or not they have done an action and then the url to their personal gallery.

The last column is a formula to put together the name, , url link.

What I want to do is have a footer cell that then puts all of those text strings together.

Sum doesn't work on cells with text. 

How can I add all of the text strings in all of the cells in one column together, without having to manually input each cell into a formula?

Some projects have 5 rows, which isn't too bad. However, the job I am currently attempting to track has 70 people. 

It gets a little unwieldy to have to build a formula of A2&amp;" "&amp;B2"&amp;etc etc etc.

Can I automate that in Numbers?
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.