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.

[Entertainment-ttwe]

Wanted to know how to split cell not the data in it

[tonyrosales]

just show how to split a cell inside the cell, one cell become 2 cell with a divider like a box

[wj]

You didn't split the "cell"...you split the data 🙄

[alexwilson]

Thank you much man you made my day I really need it

you split the text into cells.. you did not divide a single cell.

[callumshepherd]

an absolute complete waste of my time, not one cell was split thanks