Is there an upper limit of text that comments can hold

M

MarkRC

I have hundreds of comments in a spreadsheet. Some of these comments hold
pages and pages and pages of text. I am getting concerned that there might
be an upper limit of text that can be held in each comment. If some of this
information gets dropped/truncated, I am @#$%^.

Is this going to be a problem for me?

Thank you very much for the help.
 
J

JE McGimpsey

Each cell can contain 32767 characters, of which 1024 can be displayed
(more if linefeeds are added).
 
P

PokerZan

(more if linefeeds are added)
Click to expand...

Ok, what are "linefeeds" and how can I add them? I too have multiple
comments fields within a spreadsheet and I have had problems linking
the comments to a master sheet.

PZan
 
J

JE McGimpsey

I was thinking of cell contents, not comments. As far as I know
linefeeds (CHAR(10), OPT-Enter) are irrelevant for comments.
 
Top