How to split cells containing text in Excel
Learn how to split cells with text in Excel using this quick and easy tutorial.
Splitting cells in Excel allow you to manipulate data in a single cell and distribute it to adjacent cells.
To split a cell, open the Excel document and highlight the cell you wish to split. On the top tool bar locate the 'data' tab and click on 'text to columns', this will prompt you with how you wish to split your Excel cell.