Convert Text to CSV format
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
|