Don't copy and paste, just open the *.txt file in Excel.

The Text Import Wizard will pop up to allow you to designate de-limters.


Gord Dibben MS Excel MVP

On Mon, 7 Dec 2009 13:12:02 -0800, John Calder
wrote:

Hi

I run Excel 2K

I have a text file that has mutiple columns of data that vary in width. When
I copy & paste this into Excel all the information ends up in one column. I
need to be abale to get all the various coulmns in the text file to go into
individula columns in Excel.

Is there a way of converting the text into a tab delimited file so that I
can achieve this?

Thanks