2

i.e. if a cell looks like

A

B

C

 

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

Functionality

Comments

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)