Alain,

AFAIK there is a limit of 1024 characters that can be
displayed in a cell, although this can be increased with
use of Alt+Enter (line break).
However a cell can contain 32,767 character.

If you are using a text file you could look into breaking
your lines up with delimiters, which will import back into
rows of cells.

Regards,
Sandy

-----Original Message-----
Hi!

On my invoice sheet, I store the information in a .txt
file. Each line of the .txt file contain all the data of a
particular invoice.

In Excel, before hapening it to the file, I build this
line like this :
Line = line & NextData & "~" . The ~ as a separator.

This make the line quite long and for my needs, it is
still Ok. I have no problem with that. I am just curious
to know if there is a limit to the length of a line like
this one.

Thanks.

Alain


---
Message posted from http://www.ExcelForum.com/

.