Create at least two columns next to the column with the data you want to split.
Then click the little triangle and select “Insert 1 right”. Repeat to create a second free column.
In the first free column, write =SPLIT(B1,"-"), with B1 being the cell you want to split and - the character you want the cell to split on. (If you see the error #REF! in your cell, you’ll need to create more columns.)
To apply the changes to the cells below, drag down the blue square in the bottom right of the selected cell(s). Double-click on the blue square to fill all remaining cells.
I hope this helpful!
Admin
Apps4Rent