Step 1: To split these cells into their separate parts, select them and then click on Text to Columns in the Data menu. Mark Coppock/Digital Trends Step 2: In the dialog that pops up, you'll need ...

How to Merge Cells in Excel . On top of making a sheet’s layout look clean, combining cells can also help group related data. That way, you don’t have to stretch cells to show more information.

How to Split a Cell in Excel 2007. Even if you've never created a merged cell in a business spreadsheet, you may receive a spreadsheet that has one. Excel allows you to combine multiple cells into ...