I have a puzzling problem. The attached file is contains a single record from a much larger tab delimited text file. When I attempt to open this file in Excel using File->Open and select 'Delimited', then on the next screen, make sure Tab is selected then click finish, this particular line is truncated immediately after the 'next' at 'next adjacent'.
I have checked the text with a hex editor to see if there are any control characters there but nope:
[FONT="Courier New"]0C69:0200 6E 20 74 68 65 20 6E 65-78 74 20 61 64 6A 61 63 n the next adjac[/FONT]
There are much longer lines than this in the file that load correctly. Any one have any ideas why this is happening ?
The file itself is a list of texts used in a web site that are being made available for translation. The format is Record_type, Message Number, empty, Message Text.
Please note that the text file does contain HTML tags.
I'm using Excel 2000 (9.0.2720)