I have a enum list of employees. when I select multiple employees and go to the excel file it looks like this: Josh , John. I would like to make the formatting Josh, John. Is there a way to do this?

Personally, I think I would let AppSheet record lists in the way it likes to (“Josh , John” etc) and then use SUBSTITUTE() to fix it. SUBSTITUTE() is available in AppSheet and spreadsheets. In Google sheets it would be something like this: SUBSTITUTE(A2," , “,”, ") https://support.google.com/doc…

Remove space between Enum list item and comma

AppSheet AppSheet Q&A

Steve March 19, 2020, 12:27am 6

Joshsbk:

I would like to make the formatting Josh, John.

Why?

Topic		Replies	Views
¿How to separate Enum List by a line break? AppSheet Q&A databases , expressions	4	23	February 14, 2020
Merge an ENUMLIST & Select() into another ENUMLIST AppSheet Q&A expressions	14	7	November 26, 2021
Enumlist values are parsing out when sent to csv AppSheet Q&A expressions	4	0	May 7, 2020

Remove space between Enum list item and comma

AI Suggested topics