JOIN text function over multiple ranges

Cory Griffis

I am trying to create a formula that will join a group of element IDs from two entire columns. My latest failed attempt is below:

=JOIN([Element 1 ID]:[Element 1 ID], [Element 2 ID]:[Element 2 ID], ", ")

I'm not sure if I just have the syntax wrong or if the JOIN function is not capable of including multiple ranges. I suppose I could have a formula for each column then join the resulting cells for one group, but I am hoping there is a less convoluted approach.

The goal is to be able to copy all of the Element IDs as a single string of text for pasting into another program.

Thanks in advance. 

Nic Larsen

Try: 

=JOIN([Column1]@row:[Column2]@row, ",")

Cory Griffis

This screenshot might better show what I'm attempting. In this example, I need all 10 element IDs to be joined into a single string in one cell. 

Nic Larsen

Understood. You can still do it, it'll just be a bit long with 10 columns. This worked for me. The last column you'd leave off the JOIN function. 

=JOIN(([Column1]@row) + ",") + JOIN([Column2]@row) + "," + [column3]@row

Paul Newcome

Try something like this...

 

=JOIN([Element 1 ID]:[Element 1 ID], ", ") + ", " + JOIN([Element 2 ID]:[Element 2 ID], ", ")