Hi,

Enter the formula in one cell in relative reference (For eg. =Proper(A1)
and not =Proper($A$1)) and copy it across to the range you need.

Regards

Govind.

cmurdock wrote:
I am trying to change the case from uppercase to title case on several cells
in a worksheet. So far, I can only use "PROPER" to change case in one cell.
How do I apply the "PROPER" function to more than one cell?

Thank you so very much!