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

Hi John,

The short answer is probably, but you'll need to provide more details about what app you're copying the data from and how the data
are formatted in that app.

--
Cheers
macropod
[Microsoft MVP - Word]


"John Calder" wrote in message ...
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

Use the "Text to columns" function. When you have pasted the data into A1
ensure that only col A is selected then select Text to columns. This allows
you to chose the delimiters (spaces in your case I expect) and then check and
change or introduce lines to separate the columns. You then have a limited
choice of formatting - Date - Text - Numbers - and ignore I think. It's a
really useful tool. Not sure of it's availability in 2000.

"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

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