Keep in mind that an Excel file is more than a file extension! What you're asking is best answered if we know your INTENT.
The only way (that I know of) to make a text file into an Excel file is to open it in Excel and allow Excel to load the data into an Excel format and then save the file. changing the file extension doesn't change the FILE, what it does is tells Windows to use Excel when opening the file. You could do the same thing by changing the Windows File associations to use Excel.exe to open any file with a .txt extension. But when Excel opens the file, it will STILL need to use some mechanism to "import" the data and display it in an Excel format. So your question: Is there any way to convert text file to excel, except change of extension name... does not make sense from the standpoint that changing the extension does NOT convert the text file to Excel. So, either I'm misunderstanding what you mean by "convert text file", or at the least, we need to understand what it is you're trying to accomplish... Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Ram Naresh Verma <rnverma2...@gmail.com> To: excel-macros@googlegroups.com Sent: Thu, September 22, 2011 1:35:36 PM Subject: Re: $$Excel-Macros$$ Convert txt file to xls sandeep, go to command prompt go to the directry where the txt file exist use command ren abc.txt cld.xls it will definately work.... i had tried the same... On Thu, Sep 22, 2011 at 4:20 PM, Sandeep Pathak <sandeeppathak...@gmail.com> wrote: Dear Team, > >Is there any way to convert text file to excel, except change of >extension name... > >Please advise... > >Regards, >Sandeep > >-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > -- Regards, Ram Naresh -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
