View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 293
Default Convert Text to CSV format

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