I just figured out that this existed (=PROPER to change fields that are capitalized, so that the first letter of each word is capitalized), yay! But am having the dumbest issue with it: my workbook displays the formula, not the result.
Odd. I did check that the Show Formulas was deselected. I just retyped the formula, and suddenly, it worked. The same thing happened when I tried to use this function again in a different column. Thanks very much!