Excel Guides

Splitting Cells by Case in Excel

In Excel, you can split cells by case by using the Text to Columns feature. To do this, first select the cells that you want to split. Then, go to the Data tab on the ribbon and click on the Text to Columns button. In the Convert Text to Columns Wizard, select the Delimited option and click Next. On the next page of the wizard, check the Other option and enter a space in the box next to it. Then, click Finish.

Your cells will now be split by case!

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.