How To Copy Paste Tab Delimited Text Into Excel 10 Steps

You can quickly select the entire column by clicking the letter at the top. You can only use Text to Columns on a single column at a time.

If you’re using Office 2003, click the Data menu and select “Text to Columns”.

Choose “General” for numbers or a mix of numbers and letters. Choose “Text” for data that is just text, such as names. Choose “Date” for data that is written in a standard date format.