JOIN text function over multiple ranges

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.

Find more posts tagged with

Formulas

Comments

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], ", ")

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…