View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
John Calder John Calder is offline
external usenet poster
 
Posts: 176
Default Convert Text to CSV format

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