Excel.Tips.Net ExcelTips (Menu Interface)

Text to Columns

Tips, Tricks, and Answers

The following articles are available for the 'Text to Columns' topic. Click the article's title (shown in bold) to see the associated article.

Converting an Unsupported Date Format
Excel makes it easy to import information created in other programs. Converting the imported data into something you can use can present a challenge. Here's how to make a change from an unsupported date format to one that Excel can work with.

Fixed-Width Settings when Converting Text to Columns
The Convert Text to Columns capabilities of Excel are very helpful when pulling apart information. When working with fixed-width data, you may want a way to "override" what Excel suggests as breaking places for the data. Here are some ideas.

Separating Names into Individual Columns
If you have a list of names in a column, and you want to separate those names into individual cells, there are several approaches you can take. This tip discusses how you can pull out various parts of the names in your list.


Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us


Advertise with Us

Our Privacy Policy

Our Sites


Beauty and Style




DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)



Home Improvement

Money and Finances


Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives


Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.