commas after each choice in a multi select row

Paula Cosentino

Hello,

I have a helper row where I want all the selections FROM A MULTIPLE SELECTION column to appear.  I got it to work, but I would like a comma separating the selections. 

What I'm exactly trying to do is combine all the selections in the Multi-Select "SPECIALTY" column PLUS the single item in the "SUB-SPECIALTY" column.  I can get the comma between the columns, just not after each of the selections in the first column

=Specialty@row + ", " + [Sub-Specialty]@row

I need a row that can be text in order to export it to Sharepoint.  Thank you in advance for any help!

I attached a screenshot

Paula

Paul Newcome

The delimiter in a multi-select column is a line break which is CHAR(10), so you can use a SUBSTITUTE function to replace the CHAR(10) with a "comma space".

 

=SUBSTITUTE(Specialty@row, CHAR(10), ", ") + ", " + [Sub-Specialty]@row

Paula Cosentino

wow, thank you so much for taking the time to teach me this formula!  I appreciate you.  

Paul Newcome

Happy to help! 

Chris Neary

@Paul Newcome and @Art Schneiderheinze -- I discovered this thread, as I have a similar issue with parsing out multi-select options. This was amazingly helpful. Thank you!