Excel: Split cells
In Microsoft Excel, several values can be divided from one cell - for example, to make a table clearer. You can read how to do this in this guide.
Split cell values
- First select the cells whose content you want to split into several cells.
- Then click on the "Data" tab above.
- Then select the menu item "Text in columns".
- In the "Text Conversion Assistant" click on the entry "Separated" and then on "Next".
- Place a checkmark in the "Separator" field in front of the "Space" entry. You should also ensure that there is also a check mark in front of the entry "Treat consecutive delimiters as one character". This avoids space errors.
- Click on "Next" and confirm with "Finish". Now the content of an Excel cell is divided into several columns.
Windows 7 and Microsoft Excel 2007 were used for this practical tip. If you want to analyze the data of the divided cells further, read here how you can compare several Excel cells with each other.