End of file marker from Text File - Delete?
 

How can I get rid of an EOF marker that's in an imported text file? The
text file is created from within a FPD2.6 program, which automatically puts
the EOF marker/code there. When Excel opens it, of course it just shows up
like a little box. This won't always be in the same row, although will
always be in the same column.

Is there a way to eliminate this using VBA? I open the text file, then copy
the data into another spreadsheet. I have no way of knowing the number of
"records" that will be copied, so I just copy the entire sheet.

Thanks!
Shawn