Can't paste more than 255 characters

  • Thread starter Thread starter Jeff Thomas
  • Start date Start date
No there is not. 255 characters is a limitation of Excel. No more than 255
in a cell.

Tony Law
 
Hi Jeff,
Tony is not quite right. 255 is the max column width. Try formatting the
cell with "Wrap Text" on the Format|Cell|Alignment dialog.

See help under 'specifications' for actual limits.You'll find

Column width 255 characters
Length of cell contents (text)
32,767 characters. Only 1,024 display in a cell; all 32,767 display in
the formula bar.



Bernard
 
It should work fine, up through 32K characters, although only 1024 may
display. What problem are you having?

--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How can I copy more than 255 characters in a cell without truncati 1
Paste problems 1
Why can't I get more than 255 characters in one cell in Excel 07? 1
How do I get more than 255 characters into a cell? 3
Excel character limitations 1
Word wrap with > 255 characters 2
more than 255 character in one cell 1

Back
Top