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!