I am trying to use the PROPER formula to correct the case of names in a data
base.
The formula will not calculate. I have set the Calculation button in tools
options to automatic. I have also tried the CTRL+` step. This happens whether
the cells are formatted to be locked, unlocked, hidden or not.