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.
Pastimes : Computer Learning

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: TimbaBear who wrote (21136)7/2/2001 9:07:30 PM
From: thecow   of 110652
 
TB

If you can open the file with notepad and then save it as a text file you can do what you want. In excel, go to file open and browse to your new text file (In the open box change to files of type to txt and select your file)and double click it. That will open your text import wizard. Put the checkmark in the delimited radio button and click next. That will give you a data preview window where you can preview the way the data will be imported. If it's not what you need you might try some of the other delimiter settings until you have what you need.

tc
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext