Split multi line cell value from Google Sheets into an array

[Kenni_Larsen]

Hi experts!

Any idea on how I would be able to split multi line cell values from Google Sheets into an array?

[Callinetic]

Hi @Kenni_Larsen ,

You can transform your multi-line cell value into an array with the split() function. As parameters, you first pass your cell value and then select the newline option from the text functions.

{{split(<Your variable>; newline)}}

I hope this answers your question.
Glenn - Callinetic