Importing large text file-limitations?

[Chuck F.]

When importing a flat text file, ~ delimited, all works
well except for one column. Some larger records (3,000 to
5,000 characters) do not display the whole record in the
cell. I can force Excel to recognize the whole record (Get
Data external and manipulating cell validation and
refresh) but cannot get the whole cell contents to display
or print. Is this an Excel limitation?

 

[Dave Peterson]

Left to its own devices, Excel will display about 1000 characters in the cell.
It'll display all 32k in the formula bar.

If it's possible, you could add alt-enters to your long strings and you could
see more.

 

[Guest]

-----Original Message-----
Left to its own devices, Excel will display about 1000 characters in the cell.
It'll display all 32k in the formula bar.

If it's possible, you could add alt-enters to your long strings and you could
see more.



--

Dave Peterson
(e-mail address removed)
.

 

[Dave Peterson]

I think you'd be better off to use a unique character. If you use an actual
carriage return, then it'll look like a new line that should be imported into
the next row.

If you use a combination of characters ($$$$$), you could always import the file
and do
Edit|Replace
$$$$$
with
alt-0010 (From the numberkeypad--not above the QWERTY keys).

(You may have to Format|cells|alignment tab|wrap text to make it look pretty)