Max number of characters in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have more than 1024 characters in a cell? I have tried to
use char(10) and char(13) however while the formula allows me to copy and
paste more than 1024 characters it limits my statements to 100 characters
after 1024. Is there any way to go around this and be able to have as many
characters as one wish in a cell.

Thanks
 
You might search on "limits" in Excel help for this and other limits. A
cell can hold a text entry of a max of 32k characters. A formula can have
about 1000 characters.
 

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

Excel text export limit - 1024 per line (not cell), workaround? 11
Error message is Character Limit is over 1024 characters 2
Microsoft Excel Cell text limits 3
Chracter Limit Help!! 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Is it possible to enter more than 255 characters in a cell 2
Number of characters in a cell (one row, merged columns) 1
Maximum Characters in a cell 1

Back
Top