If you want to split a series, you can press 'Shift' and drag your cursor down to select multiple cells. Select your cellsĬlick on the cell you want to split. Here's a list of steps you can follow to split cells into columns with the Text to Columns Wizard feature in Excel: 1. Related: How To Sort Data in Excel: A Step-by-Step Guide How to split cells into columns in Excel using the Text to Columns Wizard Reformatting: If you paste information from another source, like a website or email, you could split it into columns to separate it by category.Īnalysis: When analyzing data, isolating a part of each column might allow you to focus on just one data set. Readability: Separating your information into smaller chunks might help a viewer scan the spreadsheet more easily.
Splitting cells into columns could also be useful for: For example, if you have a list of addresses, you could split the number and the streets into two separate columns and alphabetize them by street name.
Splitting cells can be valuable if you want to re-sort information by more specific criteria. There are many situations in which you might want to split one cell into multiple columns.
