Excel

How to Split Cells in Excel

How to Split Cells in Excel

There are a few ways to split cells in Excel. One way is to use the split function. To do this, type "=SPLIT(cell reference,split type)" into a cell, and then drag the autofill handle over the cells you want to split. The split type can be a number, a text string, or a delimiter. Another way to split cells is to use the text to columns function. To do this, type "=text to columns(cell reference,delimiter)" into a cell, and then drag the autofill handle over the cells you want to split. The delimiter can be a space, a comma, a semicolon, or a tab.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.