Solved: ¿How to separate Enum List by a line break? - Page 2

Rene_Casana_Ama · 02-13-2020 08:50 PM

I have a column with a filtered list by formula that is EnumList type and I need to separate those values not by comma " , " but by a like break so that the list in my google sheet column is like this:

234235
234255
635645
375773

It’s bassically a list of key values. that I need to have in a list format but sepparated by new line character.

I alredy tried to put a pilcrow in “Separator” parameter for the EnumList but only shows the values as follows: 15eb521a,9e2c37f8,9aa024d8

MultiTech

This sounds like something that would seriously affect performance of the app - at least the sync time would be.

I’m surprized @Steve didn’t throw out his customary response for this question:

SUBSTITUTE([Item_List], ",", "
")

View solution in original post