Spell check strings

[AndyC812]

Hi,

I ahave a huge app with lots of strings embedded in formulas. Is there a
way to spell check within a formula? For example:

=if(c43="","",Q45&"can only spell assignned the wrong way. ")

Spell check will not pick up the fact that I misspelled "assignned", and as
you can see I cannot spell. ;-)

 

[Sheeloo]

Try this
1. Find = and Replace All with ^^^ (a combination which is not likely to be
used on your worksheet)
2. Run spell check
3. Find ^^^ and Replace All with =

 

[AndyC812]

Great idea!
--
Thanks,
Andy

Try this
1. Find = and Replace All with ^^^ (a combination which is not likely to be
used on your worksheet)
2. Run spell check
3. Find ^^^ and Replace All with =