nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Discussions
Groups
Discussions
Get Answers
News & Announcements
- Community Corner Newsletter
- Product Announcements
Topics
Events
Product Ideas

Title

Gen Test

=IFERROR(MID("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", FIND("|", SUBSTITUTE("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", "!", "|", Number@row)) + 1, FIND("|", SUBSTITUTE("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", "!", "|", Number@row + 1)) - (FIND("|", SUBSTITUTE("!" + JOIN(DISTINCT(COLLECT(List:List, List:List, @cell <> "")), "!") + "!", "!", "|", Number@row)) + 1)), "")

Formula is in [Column2] of the below snippet:

Find more posts tagged with

Accepted answers

All comments

There are no accepted answers yet

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of