Hi everyone, I have a dropdown column that is able to receive multiple selections let’s say a user chooses “apple” and “orange”.
If I want to use that data within a sentence for an acknowledgement email it would read something like this: “Hello and thanks so much for your interest in our apple, orange product.”
Is there a formula or other way to replace the comma that separates the individual product selections with something like “&” so it would read: “Hello and thanks so much for your interest in our apple & orange product.”
I’ve tried the REPLACE formula, but that seems more focused on specific character replacement.
Thank you for your help!