How to split multiline cells into individual cells?

Hi myi,

You've got two ways to do this:

1. Manually select the text in the cell and copy/paste it into a new cell
2. If you're wanting a more automated solution, you might consider creating text formulas in your separate cells that splits this text up. More information on our functions is available in the help center: https://help.smartsheet.com/functions (use the dropdown on the functions site to filter on Text functions)

Yes if you use this formula. =[column name]@row + " " + [column name]@row. You can do this for 2 cells for sure. Unsure if more than that. In the cell you want the data to merge do = then click on the cell with the first set of data. Add a + sign. Then add + and click the second cell. The + sign pulls them together. If you require a space or other identifier between the data " " puts a space between the two or add in your identifier between the " ". We used this to combine first and last names from a data import. If you then right click the cell and annotate it to be a column Fx it will continue to do that for the entire sheet. Hope this helps.