I've got a field in a DB that collects the Title of a presentation.

The data comes from the presenters themselves and capitalization is random.
Some capitalize like it's a sentence, others use Title caps.

I want to use a calc to replace the randomness with a consistent "style",
but the hitch to simply using the PROPER function are abbreviations used in
titles.

"HIV," "AIDS", "U.S.", "DNA", etc... are converted to "Hiv," "Aids", "U.s.",
Dna" when you use the PROPER function.

Any suggestions on a calc that capitalizes words and not abbreviations?

Thanks,
Steve

In article <C17F9073.F043%steve.mcgillivray (AT) asu (DOT) edu>, Steve McGillivray
<steve.mcgillivray (AT) asu (DOT) edu> wrote:

Unless you plan on somehow listing and checking ALL "words" that are
really meant to be abbreviations, then it's not possible for the
computer to know which is which. Even if you did list / check them all
there will be exceptions anyway. For examples, does "Aids" mean the
medical "AIDS" or the helpful "aids".

The only real answer is to train the Presenters to enter the data
properly in the first place ... or have someone else manually go
through editing any new records that have been entered for that day /
week / etc.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)