Concatenate causes Randomizer to eliminate commas

Hello! I’ve got a button that posts a randomized list of names to Slack (when standing alone in the formula, it displays as “Name, Name, Name, Name”.) However, when I concatenate the randomizer to the string "Today’s MC Order: " it gets rid of the commas and spaces that separate the randomized names and displays as “Today’s MC Order: NameNameNameName”

Any clue how I can concatenate the intro phrase but keep the separating commas?


instead of using Concatenate()

try using

myList.Join(", ")

this concatenates each item in the list with a comma and a space between each one.



(And then if you still want "Today’s MC Order: " you can concatenate that part, but use @Xyzor_Max 's solution for the list part)


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.