How to Merge or Split Cells Data in Microsoft Excel

1. Open Excel 2010. Type some random numbers in cells A1, B1 and C1. Highlight cells A1, B1 and C1.
2. Click the 'Home' tab and select 'Merge and Center.' The cells will merge as one large cell displaying information from cell A1.
3. Split the merged cells by selecting the newly merged cell. Click 'Merge and Center' icon. The cells will split displaying three separate cells again.