Using IF statement with Spell check

C

Craig

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.
 
T

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing language for spell check not working? 1
Spell Check function in an IF statement? 2
Referencing a cell even if its contents are moved moved/replaced 6
How do I sort data without messing up cel linked equations? 8
Using Drop Down list to an If Statement to another Drop Down list 3
IF Statement or VLOOKUP 1
Development combinations with exclusion of columns 0
If Statement 6

Top