You can use text to column option in excel by using , as a separator and get the data in excel in columnar form.
Thanks & Regards... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 (0361-2603895,9435019908 From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Akhilesh Karna Sent: Friday, December 19, 2008 8:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: , is to .csv as ____ is to .xls 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
<<inline: image001.jpg>>
