Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 05, 07:24 PM
Hans Emilio
 
Posts: n/a
Default 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   Report Post  
Old May 20th 05, 10:11 PM
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Old May 24th 05, 08:11 PM
Hans Emilio
 
Posts: n/a
Default

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   Report Post  
Old May 24th 05, 11:27 PM
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Old May 25th 05, 02:25 PM
Hans Emilio
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I have spell check ignore errors and alert me to real words? JenLynFish Excel Discussion (Misc queries) 1 May 9th 05 06:22 PM
How do I spell numbers as words for writing checks in Excel? Heather Excel Worksheet Functions 1 March 11th 05 08:47 PM


All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017