Using IF statement with Spell check
If you had a list of the correctly spelled words in a range of cells then
you could check them but this doesn't sound like what you want.
--
Biff
Microsoft Excel MVP
"Craig" wrote in message
...
Is there a way to use an IF statement to check words and denote if they
are
spelled correctly? For Example, A1=cat; A2=dgo; A3=mouse.
B1=If(spellcheck(A1),1,0) yields a "1"
B2=If(spellcheck(A2),1,0) yields a "0"
B3=If(spellcheck(A3),1,0) yields a "1"
This would automate the checking of a column of words rather than stepping
through "IGNORE" commands using SpellCheck.
|