Quickly Turn Text to Column in Microsoft Excel

Clean and Organize Messy Data using Excel's Text to Column Feature. 

Are you often given data with full names, addresses, or other values crammed into a single cell? Microsoft Excel's Text to Columns is a quick and effective remedy for this. A few clicks are all it takes to split any text string into multiple columns, based on commas, spaces, tabs, or a custom delimiter. 

Working through CSVs, tidying imported contact lists, or grooming data for analysis—learning this tool is a step that will immensely simplify your data preparation process.

🔍 What is Text to Columns in Excel? 

Text to Columns splits up the contents of a cell (or column) into several columns using a delimiter (for instance, a comma, space, or tab). It's handy for:

• Separating first and last names 
• Splitting out the city and state fields
• Splitting multi-part product codes
• Cleaning up messy imports from databases or websites

🛠 How to Use Text to Columns in Excel

Step 1: Select Your Data

Click the column that contains the data you want to split.

Step 2: Go to Data -> Text to Columns

This will open the Convert Text to Columns Wizard

Step 3: Choose a Split Method

• Delimited: Select this when your text is separated by commas, spaces, tabs, or custom characters

• Fixed width: Choose this when each field has the same number of characters

Click Next.

Step 4: Set the Delimiters

Tick the box that corresponds to the goal delimiter:

• Space
• Comma
• Semicolon
• Tab
• Or enter your custom character

Clicking Next and then Finish will apply the changes.

Example: Split Full Names into First and Last

You have a column:

John Smith

Alice Brown

Raj Patel

Select Delimited and check Space under the delimiter options. Excel will separate first and last names into two columns in an instant.

💡 Pro Tips

• Make a backup copy before splitting data cannot be undone once split
• Use Text to Columns for importing CSV or TXT files to clean them instantly
• Combine with Flash Fill or formulas for more transformations
• If your data contains different delimiters (say, comma and space), turn to Power Query for advanced parsing

With Text to Columns, you free yourself from hours of tedious manual editing and impose order upon even the worst datasets. It's one of the strongest data-cleaning tools Excel provides-simple, yet every data analyst, business user, and spreadsheet enthusiast should have it in their toolbox.

Open Excel and start splitting!

🎓 Learn More with Other Levels

Take your Excel skills to the next level:

• 🌐 Visit our Other Levels Website

• 📺 Watch free tutorials on our Other Levels YouTube Channel, and learn Microsoft Excel from beginner to advanced.

✍️ Other Articles, Tips & Tricks you would like:

• Using Formulas Create a Running Total in Microsoft Excel
• Quickly Replace Data with Find and Replace Function of Microsoft Excel
• Easily Analyse Data with Microsoft Excel's Data Analysis Toolpak

Work Faster, Smarter, Productively and Efficiently with Other Levels Dashboard Template

• Finance Payroll Management Dashboard
• Personal Finance Excel Dashboard-Excel Mobile Version
• Project Financial Insight Excel Dashboard