Hello,

I have data files (1 per day) that are downloaded from a vendor site. The
files come accross with a WR1 extention. I beleive this is a Lotus Syphony
format.

The data length of each row is about 480 characters in the WR1 file.

When i import the data into excel 2007...it is truncating the data at 255
characters. I thought that cap on cell length was eliminated in 2007.

So I tried opening the file using MS Word. the full row was shown. I
copied and pasted the data from Word into excel and the full row with 480
characters shows up in the first cell.

That is the result i am looking for, but would love to have it happen in
just one step. I do not want to have to open in word and transfer to excel.

Once the data is in the single cell in Excel, i can easily parse the data
according to the record layout.

So any idea why i cant import the text or open the text file in Excel 2007
without truncating the data?

Many thanks for your suggestions.
PivotMan