=proper, only dictionary

[Sharks1777]

Hi Team,

I did some searching for this topic, but admittedly, I might not be realizing how I should even search for this...

I use =proper a lot because I will enter part numbers and descriptions into our system. Trouble is, a lot of suppliers use all caps. When I use =Proper things that should be capitalized is converted to lower case. Like "USA" becomes "Usa". (example, USA power cord).

Is there a way to use =proper, but only have it search for dictionary words only and skip all else?

 

[Rick Rothstein]

While checking a dictionary for words might work for some words (not sure if USA is in a standard dictionary or not), it would not work for, say, "US POWER CORD" as US is a real stand-alone word. I don't know your data, but is it possible to build a list of exception words that can be checked against and used to correct the text after applying the PROPERT function? If so, I am not sure off-hand if a formula solution would exist or not but a macro (or event code) could be written to do it.

 

[Sharks1777]

While checking a dictionary for words might work for some words (not sure if USA is in a standard dictionary or not), it would not work for, say, "US POWER CORD" as US is a real stand-alone word. I don't know your data, but is it possible to build a list of exception words that can be checked against and used to correct the text after applying the PROPERT function? If so, I am not sure off-hand if a formula solution would exist or not but a macro (or event code) could be written to do it.

Thanks for the feedback. So there wouldn't really be a way to say "=proper(dictionary(" for example? I'm good with the few things that it might change in error like your example of US = (United States) vs us (me and you). I am mainly thinking about things like BNC Cables or RS/232 for example. It changes both to "Bnc Cable" and "Rs/232" both are so very minor it is almost not even worth the fuss, but I keep thinking there must be a way.