Excel Tips: Using Text-to-Columns for Data Cleaning

Splitting Data in Excel

When working with contact lists or logs, you often get data clumped into a single cell (e.g., "John Doe, 555-0199"). Here is how to split it.

Using the Text-to-Columns Wizard

1. Select Data: Highlight the column containing the combined text.
2. Go to Data Tab: Click on Text to Columns in the ribbon.
3. Choose Delimiter: Select "Delimited" and click Next. Check the box for Comma, Space, or whatever character separates your data.
4. Finish: Click Finish. Your data will now be neatly separated into columns.