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.
