Hi

I open the CSV file (Source of the file is WWW), although the required format is present when view through the web but when saved, all the entries appear in first column i.e., all the formatting is erased. Now I use Text-to-Columns to delimit the single column format but then when I try to save the same file into *.xls I can't see any excel format. All I can see is a *.txt format. Any way to fix this?

Already tried the following but resulted in nothing:
http://kb.paessler.com/en/topic/2293...ay-to-fix-this

http://superuser.com/questions/40708...ommas-in-excel

MS Excel: 2010
Region: USA