Parse Cell

[tvinci]

Hi AppSheet Community,

This is what my backend looks like when a user selects a route. I would like to split the client name column by comma to create new rows. Does anyone know how to do this? I tried using the split() function but it works with columns and it doesn’t work on importrange().

Thanks!

[tvinci]

I would like to insert a line break in the item separator here:

[Aleksi · Accepted solution]

You can do that with a combination of SPLIT() and INDEX(). For example like INDEX(SPLIT([Client Name]," , "),1) and the result would be “4 Corners Animal Hospital”

[tvinci]

Thanks @Aleksi

Here is what happens when I attempt that:

Here is what I input into the separator field:

[tvinci]

I also tried putting it into suggested values:

[tvinci]

The code worked on Google sheets, but it only displays 1 of the many client names. I want a new row for every client name. Thanks again.

[tvinci]

Ah! I omitted the ,1 at the end of the formula and got what I wanted. Thanks.

[Aleksi]

You’re welcome