How to use JOIN to join non-adjacent Cells

mistone

Can I use the JOIN Function to join non-adjacent cells. For example I want to the result to be:

Sat - 04/01/23 - Introduction to Outdoor Rock Climbing.

My attempt at a formula:

=JOIN(([Day of week]@row + [Start Date]@row + [Start time]@row + Itinerary@row), " - ")

The Result - a string of text without a - :

Sat04/01/23Introduction to Outdoor Rock Climbing Class

You'll notice the cells are non-adjacent so I don't thinking using the standard JOIN structure of =JOIN(Example174:Result174, ", ") will work.

Eric Law

@mistone , Since you are not joining a specified range and just piecemealing it together, why not just make your formula, =([Day of week]@row + " - " + [Start Date]@row + " - " + [Start time]@row + Itinerary@row)?

Eric Law

@mistone , Since you are not joining a specified range and just piecemealing it together, why not just make your formula, =([Day of week]@row + " - " + [Start Date]@row + " - " + [Start time]@row + Itinerary@row)?

mistone

@Eric Law -

Thanks! I didn't know how to structure the formula, so this is super helpful!