When working with Excel, you may encounter many difficulties that will slow down your work. Luckily, there are many Excel tips available online and you can find them and use them very easily. Whereas solutions to common Excel problems can be found quickly, solutions to those less common Excel problems are harder to find. One such difficulty you may experience while working with tabular data is to split cells in Excel. Oftentimes wrong data is placed together in one cell and you need to make more cells in order to split that data.
Unfortunately, there is no such option in Excel that can divide one cell into multiple smaller cells but still, there is a way to split cells in Excel. If you follow the steps below you will be able to divide content and place it in separate cells.
Firstly, select the cells you want to split. By clicking on the Data menu, a toolbar like this one shown on the image below will appear.
In the Data Tools tab, click on Text to Columns and then on Delimited option. When you click on Text to Columns, a window will show up asking you to choose between Delimited and Fixed Width.
Then click Next and another set of options will appear.
At the top of the window you will see a set of delimiters options, and you should tick one delimiter that is the most suitable. You can choose more than one delimer and in that case, tick the box Treat consecutive delimiters as one. The data preview panel shows how the data will look like when it is split in multiple cells.
When you click Next button one more time, you will be able to format column data, by setting up the options in Column data format area.
When you are done with formatting just click the Finish button.
If you are working with big data it is required to make a copy of the spreadsheet first and then to split cells in Excel.
If you are asked to replace the content of destination cells, cancel that operation, select different delimiter and modify data in the original column.
No matter how often do you work with Excel, learning new Excel skills can only help you with data analysis and other data manipulation tasks.