P
PivotMan
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
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