Welcome!

How to split multiline cells into individual cells?

myi

i.e. if a cell looks like

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

Find more posts tagged with

Sheets

Comments

Shaine Greenwood

Hi myi,

You've got two ways to do this:

Manually select the text in the cell and copy/paste it into a new cell
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)

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.

unknown

This content has been removed.

Sign in to join the conversation!

Quick Links

Trending discussions

Delete
How can I delete old sheets I no longer use from my account?
How do I get a dashboard chart based on a report to display as a donut chart?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…