Spell check strings
 

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. ;-)

--
Thanks,
Andy

Spell check strings
 

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" wrote:

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. ;-)

--
Thanks,
Andy

Spell check strings
 

Great idea!
--
Thanks,
Andy


"Sheeloo" wrote:

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" wrote:

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. ;-)

--
Thanks,
Andy