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.