How to split cells into columns in Microsoft Excel using the 'Text to Columns' feature Dave JohnsonFeb 12, 2021, 00:57 IST With Excel, it's easy to split up data from within individual cells into separate cells.justplay1412/Shutterstock You can split cells into columns in Excel using the "Text to Columns" tool. Excel gives you two ways to split cells into columns: using delimiters, or using a manual fixed width. Splitting cells into columns is a convenient way to separate first and last names, or cities and states. Microsoft Excel has lots of features that can help you manage your data. For example, say you have a hundred cells, which are each filled with a first and last name. You can use the "Text to Columns" tool to separate these two data points (first name and last name) into two separate columns, which is great for organizing your data.