I haven't used it (yet) but the "Hacker's Guide" comes with the function UL which will captilize names correctly and will handle the cases you mentioned.


>What is, in general, the best way to handle names capitalization? The simplest way is to expect data entry people to capitalize them correctly, and print them on reports as they appear in the field. That way, no algorithm needs to figure out how to capitalize names like MacDonald, O'Reilly, DiFatta, or ffolkes. However, if someone made a function or lookup table that was comprehensive enough to handle these and other examples, it could make a names table more error free than it would be if left to the data entry person.