How to add all of the text strings in all of the cells in a row together

numbers

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&" "&B2"&etc etc etc.

Can I automate that in Numbers?

Best Answer

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.

Concatenate function Function result

To add to every row, just drag the formula handle to copy the formula down. Copy formula