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. Continue reading