Spell check / character cell limit

S

Suzanne

While I understand Excel has a character limit of 32,767/cell, 1,024 display
in cell; spell check will not correct selected word(s) in a given cell with a
length over 900 (approx) characters.

Has anyone else encountered this? Can anyone shed any light on this?
 
D

Dave Peterson

I use xl2003.

I put:
=rept("this and that ",100)&"qwer"
in A1

=len(a1) reported back 1404 characters.

I converted the formula to a value and ran tools|Spelling and excel yelled at me
about the "qwer" stuff.
 
S

Suzanne

Me too on the 2003 version. I appreciate the test. I even copied the
text/cell in question to a blank workbook. Perhaps i'll figure it out
eventually. Thanks again.
 

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

Top