Garbled Left Column In Excel

[smartniches]

I have excel 2003 & when I import a csv file, the left column is all garbled & not readable.

The program I used to create the file is called auction yen, which analyses eBay's Want It now forum
& allows you to save it as a .csv file

Here are some pics of the file & also a link to download it.

http://www.smartniches.com/excel.html

Gary,

 

[PA HS Teacher]

You pictures didn't come up but I downloaded the file. I have Excel 2000 and the file looks fine to me.

excel.csv
	A	B	C	D
1	Words	Occurrences	Responses	Yen Factor
2	sterling silver	36	25	1.8
3	cast iron	26	13	3.33
4	for a	22	3	7.6
5	oil lamp	16	11	1.85
6	milk bottle	14	0	8.67
7	1 2	11	5	3.75
8	looking for	11	0	8.33
9	sewing machine	10	6	2.5
10	pair of	9	7	1.25
excel

What is information are you trying to extract, and what do you want to do with it?

 

[smartniches]

The column on the left is suppose to be words it's not readable
like it is.

 

[SydneyGeek]

Try this:
Insert a blank column between A and B
On A, Data | Text to Columns. Use the greater than symbol as the split character. That will separate the word pairs from the hyperlinks.

Denis

 

[smartniches]

I tried that & it didn't work, I'm going to email the owner of the software
& get him to help.

Thanks for all the help.

Gary