Search code examples
google-sheets

How to get create and get the values of elements in a cell based on line break

I stored the data into one cell, and would like to pick the elements value for each of them based on line-break:

Data

Flower
Balloon
Camera

Therefore, the values (Flower, Balloon, and Camera) are both in cell A1. I want to choose the first value (Flower) for cell B1, the second for cell C1, and the final one for cell D1.

Is there a way that we can store the values of the same cell (separate by line-break) into somethings like array and we can pick the expected value by index of them?

Solution

  • Use SPLIT() function and line break CHAR(10) as delimiter.

    =SPLIT(A1,CHAR(10))

    enter image description here