| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read text file
Hi,
I'm reading a text file originating from Unix using the Line Input #Filenumber statement. This goes haywire due to the fact that each line in the file is terminated with Chr(10), i.e. linefeed, only. Excel then reads the whole file into one string as Chr(13) is missing. Anybody know how to deal with this? Any help appreciated. jacob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to read all lines from a text file into cells C10:Cxxx ? | Excel Discussion (Misc queries) | |||
| Data from exported file read as text, when edited becomes a # (pic | Excel Discussion (Misc queries) | |||
| to read text tablimited file | Excel Discussion (Misc queries) | |||
| How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
![jacob[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
