Use "PROPER" to change UPPERCASE text to Title Case on worksheet
 

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!

Use "PROPER" to change UPPERCASE text to Title Case on worksheet
 

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!