ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Spell check giving "formula too long" - doesn't make corrections (https://www.excelbanter.com/excel-discussion-misc-queries/200830-spell-check-giving-formula-too-long-doesnt-make-corrections.html)

Jim

Spell check giving "formula too long" - doesn't make corrections
 
I am forced to use Excel as a word processor. Is there a character limit in
which spell check will function properly?

JLatham

Spell check giving "formula too long" - doesn't make corrections
 
In Excel 2003 there is a limit of 1024 characters in a formula. It's
something like 8192 in 2007. You could be hitting that.

Also in 2003 there are even problems displaying that number of characters in
a single cell without some trickery.

"JIM" wrote:

I am forced to use Excel as a word processor. Is there a character limit in
which spell check will function properly?


Roger Govier[_3_]

Spell check giving "formula too long" - doesn't make corrections
 
Hi Jim

If you are wanting to handle large amounts of text in a cell, you may well
find peter Grebenik's add-in useful.
It can be downloaded at
http://excelusergroup.org/media/p/2362.aspx

--
Regards
Roger Govier

"JIM" wrote in message
...
I am forced to use Excel as a word processor. Is there a character limit
in
which spell check will function properly?



Bill Sharpe

Spell check giving "formula too long" - doesn't make corrections
 
JIM wrote:
I am forced to use Excel as a word processor. Is there a character limit in
which spell check will function properly?

Personally, I'd complain to management <grin
That's cruel and unusual punishment.



All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com