| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spell Check | New Users to Excel | |||
| Spell Check | Excel Worksheet Functions | |||
| Spell check | Excel Discussion (Misc queries) | |||
| Spell check | Excel Worksheet Functions | |||
| ... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Hybrid Mode
