Re: $$Excel-Macros$$ Convert Text to xls or xlsm

2014-06-03 Thread N.Shivkumar
gt; you can,As long as ever you can.” - John Wesley* > ------------- > > *From:* N.Shivkumar > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, June 3, 2014 8:58 AM > *Subject:* Re: $$Excel-Macros$$ Convert Text to xls or xlsm > > Dear Sir > I

Re: $$Excel-Macros$$ Convert Text to xls or xlsm

2014-06-03 Thread Paul Schreiner
macros@googlegroups.com >Sent: Tuesday, June 3, 2014 8:58 AM >Subject: Re: $$Excel-Macros$$ Convert Text to xls or xlsm > > > >Dear Sir >I would prefer a macro as importing text file all the data comes in one cell >only >Your help is solicitated. > >  &g

Re: $$Excel-Macros$$ Convert Text to xls or xlsm

2014-06-03 Thread N.Shivkumar
Dear Sir I would prefer a macro as importing text file all the data comes in one cell only Your help is solicitated. N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 3 June 2014 16:55, Paul Schreiner wrote: > Are you wanting a macro

Re: $$Excel-Macros$$ Convert Text to xls or xlsm

2014-06-03 Thread Paul Schreiner
Are you wanting a macro to import it? or one-time?   Do you want the different sets on different sheets?   If you want it one-time, I'd open the file in excel and use a space and "!" as delimeters.   you'll need to clean up the headers.   If you're looking for a macro, let me know what approach yo

Re: $$Excel-Macros$$ Convert Text to xls or xlsm

2014-06-03 Thread Vaibhav Joshi
Hi You can copy paste data in to excel & use text import wizard!! Cheers!! On Tue, Jun 3, 2014 at 1:36 PM, N.Shivkumar wrote: > Dear friends > I am enclosing a txt file generated out of Cobol package. Can anybody help > in out to convert the same into excel. > Thanking you in anticipation of