¿How to separate Enum List by a line break?

[Rene_Casana_Ama]

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

[Steve]

Rene_Casana_Amaya:

so that the list in my google sheet column is like this

Why?

[Rene_Casana_Ama]

Because I need to send the list of values through email so that the end user just select the list and paste it to excel.

Pd. Nevermind, I made a solution to my necessity with macros in Excel that separates all the values in rows and then it transposes them to make a column.

[MultiTech · Accepted solution]

Rene_Casana_Amaya:

I made a solution to my necessity with macros in Excel that separates all the values in rows and then it transposes them to make a column.

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:

Expression to break this value up into items? Questions

Try: SUBSTITUTE([Item_List], ",", " ") Note that the expression itself is two lines. That’s critical!

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

[Rene_Casana_Ama]

Uhm no, my database is in google sheets, the end user will just receive a list of key values of the colum I mentioned (EnumList) “1244,5545,3355,8829,3334” and the proccess of converting the list it into cells will be done with a macro enabled workbook locally. The app is not connected with the workbook.