Silicon Investor (SI) -- The First Internet Community

STOCKTALK

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.

Pastimes : Computer Learning -- Ignore unavailable to you. Want to Upgrade?

To: RichBear who wrote (11661)	9/3/2000 12:25:33 AM
From: mr.mark	Read Replies (1) \| Respond to of 110655

hey bear, this link may prove helpful. usd.edu sorry i do not have any excel-specific skills to pass along. good luck :) mark

To: RichBear who wrote (11661)	9/3/2000 12:42:38 AM
From: Gottfried	Respond to of 110655

Bn, >One problem I had was when I created a text file I couldn't get the info to go to columns as it should ..it all went into one cell...still working on this< I've had that happen in 1-2-3, too. You may have better luck with the PARSE command. It can get complicated though. Some other thoughts... you could get a cheap scanner for $60 -80 if budget allows. Or, you could fax the data sheets to a friend who has a scanner and he could e-mail the scanned data back to you. But you'd still have to solve the one-cell problem. Gottfried

To: RichBear who wrote (11661)	9/3/2000 3:29:11 AM
From: Biggie Smalls	Read Replies (1) \| Respond to of 110655

when you try to open a text file (i.e. a .prn, txt, *.csv) excel should automatically open the Text Import Wizard. if you choose DELIMITED in the first step, you can specify what characters excel should use to break the rows into columns. if all of your text is formatted uniformly, then excel oughta do a half decent job of laying out the columns. hope this helps, big

To: RichBear who wrote (11661)	9/3/2000 3:09:43 PM
From: LK2	Respond to of 110655

RE-all the data from a text file going into one cell of a spreadsheet instead of separate columns. If you've used qbasic (that comes with Windows), you can write a very simple program to add a format character to separate your text file columns. That's how I solved the problem of pasting columns into a Lotus 1-2-3 spreadsheet. Clunky, but it works. The format character that works for Lotus is-- " " (The format character is not the quote marks, but what is enclosed in the quote marks, and is not visible when you read it with some programs. It's not visible in Notepad, but it is visible in the qbasic editor.) Regards, Larry Edit: when I copy the quote marks from this Net page and paste them back into a notepad text file, save it as a .bas file, and open the .bas file in the qbasic editor, I find that the format character is not present. So if you want to use this method, I can check what the ASCII code is for the format character. But Biggie has a much better solution, if you can get it to work.