SPLIT STRING INTO LIST Does anyone know if t...

(Fabio Oliveira) #1


Does anyone know if there is a way to split a string into a list, please?

Many thanks!

(Bellave Jayaram) #2

You can make the column ENUMLIST or make a VC which is a copy of that column.

(Fabio Oliveira) #3

@Bellave_Jayaram Hi Bellave. Thanks for your reply!

What I am trying to get at is splitting a string in a single cell (e.g. “TEXT 1; TEXT 2; TEXT 3”) into a list showing each item as a separate choice, either with ENUM or ENUMLIST formulas.

Could you clarify how exactly I can do that by using ENUMLIST or VC, please?

(Bellave Jayaram) #4

The string has to be comma separated for my suggestion to work. Otherwise I would recommend a sheet formula to split the single cell and use transpose to put the values in a column.

(Fabio Oliveira) #5

@Bellave_Jayaram Thanks Bellave! One last question, please: is there a way to make the app ignore certain commas in the string when using ENUMLIST, since they actually refer to the text, not splitting marks?

For example, in the string “November 26, 2018, November 28, 2018”, ENUMLIST turns all commas in the string into a splitting mark, and I end up with 4 choices (i.e. November 26 / 2018 / November 28 / 2018) instead of 2.

I tried using inverted commas, but that didn’t work.

(Bellave Jayaram) #6

I don’t think it will work. Can you live with a string like: Nov 26-2018, Nov 28-2018 ?

(Fabio Oliveira) #7

@Bellave_Jayaram Yeah, I think I can live with that. Thank you very much. I will try and see if it fits for the purpose.