Learn how to split one column into multiple columns in Excel. Use Text to Columns and Delimited options and use Delimiters to separate data in Excel.

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 ...

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.