Excel

How to Split a Cell in Excel

How to Split a Cell in Excel

There are a few ways to split a cell in Excel. One way is to use the text to columns function. To do this, highlight the cells you want to split and go to Data tab > Text to Columns. Select the Delimited option and click Next. Then, select the space option and click Next. Finally, click Finish. Another way to split a cell is to use the VLOOKUP function. To do this, highlight the cells you want to split and go to Formulas tab > Function Library > Lookup & Reference > VLOOKUP. In the VLOOKUP function, select the Column Index Number and enter the number of the column you want to split the cell in. Then, select the Match Type and enter the value you want to match. Finally, click OK.

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.