View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.