| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using IF statement with Spell check
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using IF statement with Spell check
Want to call for Spell check from within an IF statement. Doable??
"T. Valko" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using IF statement with Spell check
Want to call for Spell check from within an IF statement.
Doable?? No -- Biff Microsoft Excel MVP "Craig" wrote in message ... Want to call for Spell check from within an IF statement. Doable?? "T. Valko" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spell Check | Excel Worksheet Functions | |||
| Spell Check | New Users to Excel | |||
| Spell check | Excel Discussion (Misc queries) | |||
| ... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
| Spell Check | Excel Discussion (Misc queries) | |||
Linear Mode
