Function Removes Commas from Multi-Select Fields

[William_Nutt]

Hello! I’m attempting to concatenate two fields—both lookups from another table, one of which contains multi-select items separated by commas. When combining the fields via formula, the result strips out the comma separators from the multi-select field. However, if I use the formula only to display that multi-select field, the commas remain in place. How can I preserve that comma? Thanks!

[Justin_Barrett]

To clarify, I wasn’t initially saying, “Don’t use SUBSTITUTE.” I was pointing out that using it solo to get rid of all quotes without consideration of the end result would lead to greater confusion, not greater clarity.