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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com