Hello all:
I have just one file I need help with. This file has symbols for 3800 stocks. Each line has only one stock symbol. My charting program will not accept Importing these symbols unless it has .asc or .txt extensions. It also must be in comma, space or tab delimited. That's my hangup. I hardly ever work with or understand comma, space or tab delimited.
All I understand so far is that when I am on any line and I hit the "end" key the cursor will move several spaces beyond the the last letter of the symbol.
All these stock symbols are either one, two, three or four letters yet there seems to be about 10 spaces between the first letter and where the cursor stops when the "end" key is hit.
How do I get rid of all those "blank" spaces on each line so the curson stops right after the last letter of each stock symbol when I hit "end" key??
Could this be done in MS Wordpad? I have Excel ver 7 (Yes it's old but hardly ever used) I kinda hate doing this by hand for 3800 lines. Any quick and easy way for a person who almost never gets into this "delimiting" stuff?
Thanks for suggestions. agpilot Win 98SE, Excel v7
Edit: I forgot to mention that the orignal file was .xls and I deleted the stock company names and saved just the symbols on each line as that's all I want.
I have just one file I need help with. This file has symbols for 3800 stocks. Each line has only one stock symbol. My charting program will not accept Importing these symbols unless it has .asc or .txt extensions. It also must be in comma, space or tab delimited. That's my hangup. I hardly ever work with or understand comma, space or tab delimited.
All I understand so far is that when I am on any line and I hit the "end" key the cursor will move several spaces beyond the the last letter of the symbol.
All these stock symbols are either one, two, three or four letters yet there seems to be about 10 spaces between the first letter and where the cursor stops when the "end" key is hit.
How do I get rid of all those "blank" spaces on each line so the curson stops right after the last letter of each stock symbol when I hit "end" key??
Could this be done in MS Wordpad? I have Excel ver 7 (Yes it's old but hardly ever used) I kinda hate doing this by hand for 3800 lines. Any quick and easy way for a person who almost never gets into this "delimiting" stuff?
Thanks for suggestions. agpilot Win 98SE, Excel v7
Edit: I forgot to mention that the orignal file was .xls and I deleted the stock company names and saved just the symbols on each line as that's all I want.