Hi experts!
Any idea on how I would be able to split multi line cell values from Google Sheets into an array?
Hi experts!
Any idea on how I would be able to split multi line cell values from Google Sheets into an array?
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