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!
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!
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks