Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spell Checking - Special Words Not Picked Up by Excel
Hello,
When I run the spell check, Excel will not pick up certain words that are perfectly fine if you spell check it, e.g. market place, but what i meant to type what's marketplace. Is there any way that I could tell Excel to pcik up these special words so that when I run the special check it will pick it up and suggest the appropriate spelling or even better corrected to a predefine criteria, such as if market place appears in a cell change it to marketplace. I already have a list of predefine criterias where I want to replace certain words that are "correctly" spell, but I want to change them to other predefine words. That is change market place to marketplace, etc. By the way I am using a macro to run the spell check and the macro coding is: ActiveSheet.Unprotect Password:="xxxxx" Range("A:A").Select Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True ActiveSheet.Protect Password:="xxxxx" Any help or suggestions would be greatly appreciated! Kind regards, -- Hans Emilio |
#2
|
|||
|
|||
If you promise never to want "market place", then you could use:
Tools|Autocorrect Options|Autocorrect tab type: market place in the "replace:" box type: marketplace in the "with:" box This autocorrect stuff is shared between office programs (word, excel, powerpoint...) Hans Emilio wrote: Hello, When I run the spell check, Excel will not pick up certain words that are perfectly fine if you spell check it, e.g. market place, but what i meant to type what's marketplace. Is there any way that I could tell Excel to pcik up these special words so that when I run the special check it will pick it up and suggest the appropriate spelling or even better corrected to a predefine criteria, such as if market place appears in a cell change it to marketplace. I already have a list of predefine criterias where I want to replace certain words that are "correctly" spell, but I want to change them to other predefine words. That is change market place to marketplace, etc. By the way I am using a macro to run the spell check and the macro coding is: ActiveSheet.Unprotect Password:="xxxxx" Range("A:A").Select Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True ActiveSheet.Protect Password:="xxxxx" Any help or suggestions would be greatly appreciated! Kind regards, -- Hans Emilio -- Dave Peterson |
#3
|
|||
|
|||
Unfortunately I still run into problems when I want to capitalize the first
letter, Excel only accepts one type of spelling, e.g. marketplace replaced with market place, but I also wanted for when is capitalized. i.e. Market place with Market place. It will not allow me to enter a different version of the word (capitalize or uncapitalized). It will only keep one version of the word. I hope this makes sense. Thanks for your help. -- Hans Emilio "Dave Peterson" wrote: If you promise never to want "market place", then you could use: Tools|Autocorrect Options|Autocorrect tab type: market place in the "replace:" box type: marketplace in the "with:" box This autocorrect stuff is shared between office programs (word, excel, powerpoint...) Hans Emilio wrote: Hello, When I run the spell check, Excel will not pick up certain words that are perfectly fine if you spell check it, e.g. market place, but what i meant to type what's marketplace. Is there any way that I could tell Excel to pcik up these special words so that when I run the special check it will pick it up and suggest the appropriate spelling or even better corrected to a predefine criteria, such as if market place appears in a cell change it to marketplace. I already have a list of predefine criterias where I want to replace certain words that are "correctly" spell, but I want to change them to other predefine words. That is change market place to marketplace, etc. By the way I am using a macro to run the spell check and the macro coding is: ActiveSheet.Unprotect Password:="xxxxx" Range("A:A").Select Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True ActiveSheet.Protect Password:="xxxxx" Any help or suggestions would be greatly appreciated! Kind regards, -- Hans Emilio -- Dave Peterson |
#4
|
|||
|
|||
Maybe you can use different strings for each variation.
@@1 MarketPlace @@2 marketplace etc. Or do a series of edit|replaces when you're done entering data--make sure you matchcase. Hans Emilio wrote: Unfortunately I still run into problems when I want to capitalize the first letter, Excel only accepts one type of spelling, e.g. marketplace replaced with market place, but I also wanted for when is capitalized. i.e. Market place with Market place. It will not allow me to enter a different version of the word (capitalize or uncapitalized). It will only keep one version of the word. I hope this makes sense. Thanks for your help. -- Hans Emilio "Dave Peterson" wrote: If you promise never to want "market place", then you could use: Tools|Autocorrect Options|Autocorrect tab type: market place in the "replace:" box type: marketplace in the "with:" box This autocorrect stuff is shared between office programs (word, excel, powerpoint...) Hans Emilio wrote: Hello, When I run the spell check, Excel will not pick up certain words that are perfectly fine if you spell check it, e.g. market place, but what i meant to type what's marketplace. Is there any way that I could tell Excel to pcik up these special words so that when I run the special check it will pick it up and suggest the appropriate spelling or even better corrected to a predefine criteria, such as if market place appears in a cell change it to marketplace. I already have a list of predefine criterias where I want to replace certain words that are "correctly" spell, but I want to change them to other predefine words. That is change market place to marketplace, etc. By the way I am using a macro to run the spell check and the macro coding is: ActiveSheet.Unprotect Password:="xxxxx" Range("A:A").Select Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True ActiveSheet.Protect Password:="xxxxx" Any help or suggestions would be greatly appreciated! Kind regards, -- Hans Emilio -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
Thanks,
-- Hans Emilio "Dave Peterson" wrote: Maybe you can use different strings for each variation. @@1 MarketPlace @@2 marketplace etc. Or do a series of edit|replaces when you're done entering data--make sure you matchcase. Hans Emilio wrote: Unfortunately I still run into problems when I want to capitalize the first letter, Excel only accepts one type of spelling, e.g. marketplace replaced with market place, but I also wanted for when is capitalized. i.e. Market place with Market place. It will not allow me to enter a different version of the word (capitalize or uncapitalized). It will only keep one version of the word. I hope this makes sense. Thanks for your help. -- Hans Emilio "Dave Peterson" wrote: If you promise never to want "market place", then you could use: Tools|Autocorrect Options|Autocorrect tab type: market place in the "replace:" box type: marketplace in the "with:" box This autocorrect stuff is shared between office programs (word, excel, powerpoint...) Hans Emilio wrote: Hello, When I run the spell check, Excel will not pick up certain words that are perfectly fine if you spell check it, e.g. market place, but what i meant to type what's marketplace. Is there any way that I could tell Excel to pcik up these special words so that when I run the special check it will pick it up and suggest the appropriate spelling or even better corrected to a predefine criteria, such as if market place appears in a cell change it to marketplace. I already have a list of predefine criterias where I want to replace certain words that are "correctly" spell, but I want to change them to other predefine words. That is change market place to marketplace, etc. By the way I am using a macro to run the spell check and the macro coding is: ActiveSheet.Unprotect Password:="xxxxx" Range("A:A").Select Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _ , AlwaysSuggest:=True ActiveSheet.Protect Password:="xxxxx" Any help or suggestions would be greatly appreciated! Kind regards, -- Hans Emilio -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I have spell check ignore errors and alert me to real words? | Excel Discussion (Misc queries) | |||
How do I spell numbers as words for writing checks in Excel? | Excel Worksheet Functions |