Using the Text to Columns Tool One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to work in a dialog ...

When you're editing a business spreadsheet, you'll sometimes find a column of data in Excel needs to be split into two columns to improve sorting or extracting records. For example, phone numbers ...

When you're working on a data set, you occasionally need to split a column into two or more new columns. For example, if you imported a database with employees first and last names in one cell ...