How to use JOIN to join non-adjacent Cells
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.
Best Answer
-
@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)?
Answers
-
@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)?
-
Thanks! I didn't know how to structure the formula, so this is super helpful!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!