Solved: Remove space between Enum list item and comma - Page 2

Joshsbk · 03-17-2020 04:30 PM

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?

Kirk_Masden

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/docs/answer/3094215?hl=en

I’m thinking of having two columns: one that AppSheet records in the way it likes and one that you reformat with SUBSTITUTE().

In AppSheet, you would need to convert the list to one long text string with CONCATENATE() before using SUBSTITUTE().

View solution in original post