Dear Yoni, Open the csv file using excel and then save the file in XLS format this will solve ur problem. Ensure the csv file must have extension .csv check it by clicking on that file once and press F2 if you dont find the .csv in end then type .csv manually then it can be opened in excel.
Regards Mayank On Fri, Dec 19, 2008 at 8:20 AM, Akhilesh Karna <akhiles...@gmail.com>wrote: > Excel is not a text file. So you can not change a text file to an excel > file by simply changing extension or by replacing comma with other > characters. > You may try to open an excel (.xls) file with a text editor to see its > format. > > > Akhilesh Kumar Karna > > > On Fri, Dec 19, 2008 at 6:38 AM, Yonih <yoni.hir...@gmail.com> wrote: > >> >> Hey Everyone, >> >> We have a php website made for us and we are able to export reports >> from it however it exports it in .csv. I see where I can change the >> extension to .xls but then it puts all the info in one cell with , >> separating them. Does anyone know what the equivalent of , is for xls. >> is there there a symbol I can put instead of the , that would separate >> it into separate columns. >> >> Thanks >> >> Yoni >> >> >> > > > > -- Regards Mayank Patel ITC LTD 9822978041 9422749110 --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---