excel as a database

  • Thread starter Thread starter Phill
  • Start date Start date
P

Phill

Is there a limit to how many text characters that can go into a cell?

Phill
 
Yes

32,767 characters, approx 1,024 visible in the cell

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Phill,

A cell can hold 32K characters, but only about 1K will be
visible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
If you add some alt-enters, you can exceed that 1024 visible cells limit.
 
You must log in or register to reply here.

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
CSV->Excel Data Problem 1
How do I get more than 255 characters into a cell? 3
Excel text export limit - 1024 per line (not cell), workaround? 11
No. of characters in an Excel column 2
Wrapping text 1
Transfering one cell of word to excel 2
limit number of characters in cell 4

Back
Top