How to split multiline cells into individual cells?

edited 12/09/19 in Smartsheet Basics

i.e. if a cell looks like





How to get A, B and C into separate cells?



  • Shaine Greenwood

    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: (use the dropdown on the functions site to filter on Text functions)
  • megtimmi

    Is there a reverse to this solution? Say I have multiple rows that I want to have linked into a single cell.

  • Kyle Wheeler

    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.