commas after each choice in a multi select row
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
Comments
-
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
-
wow, thank you so much for taking the time to teach me this formula! I appreciate you.
-
-
@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!
