Results 1 to 2 of 2
2002-01-17, 14:30 #1
- Join Date
- Jan 2001
- Iowa, USA
- Thanked 0 Times in 0 Posts
Spelling Checker character limit? (Excel 2000-SR1/Win2K)
I've found something that I can't find an "official word" on and am wondering if anyone here has seen this. I've duplicated it on multiple machines so it seems to be consistent. Try this:
- Put several paragraphs-worth of text into a cell in Excel
- Highlight the text in the cell
- Start the spelling checker
If there are more than 255 characters selected/highlighted, I get a series of "Text is too long" error messages.
If there are fewer than 255 characters selected, the spelling check works fine.
If no text is selected, the spelling check works fine...the obvious solution is just don't select text.
This limit does not appear in Word...I had over 4,000 characters selected and started the check and it worked fine.
I searched the on-line help and Knowledge Base (and here) and didn't find a reference to a selected character limit for the spelling checker. Does anyone have info/knowledge/corroboration about this?
2002-01-17, 17:36 #2
- Join Date
- Jun 2001
- New York, New York, Lebanon
- Thanked 1 Time in 1 Post
Re: Spelling Checker character limit? (Excel 2000-SR1/Win2K)
All I can say is that MS-Excel is a spreadsheet application. MS-Word is a word processing application, and there you have your answer.
Its a shame that we find bout these limits like that, but again, if we are going to use Excel beyond what it was intended to do, well all bets are off then...
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>