SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Strategies & Market Trends : Jim's Nasdaq100 Special as a basket. -- Ignore unavailable to you. Want to Upgrade?


To: James F. Hopkins who wrote (206)3/19/1999 11:23:00 PM
From: Vitas  Respond to of 2103
 
Jim, whenever I save something from the net with numeratics on it, I hit file save as, and give it a name.

Then I open it in Excel. If it comes up where everything is left aligned into column A, I save it in Excel as a .prn file.

Close it, then open the .prn version. Import wizard will come up.

Then you can play around with it and either use DELIMITED and
go to the next screen and check off commas or spaces, or go back and choose FIXED WIDTH, and click in the line breaks. You have to be careful where you put the line breaks.

With the frame stuff, you can click on the part of the frame you want to save, then edit - select all - copy - then plaster to Excel.

Then save that as a .prn file.

If you save as text, the import wizard doesn't always pop up.

With some html files, once you have saved it it you can open it in Excel, copy the area you want, and then plaster it into a new file, and it will all fall into columns.

Vitas