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

G

Guest

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!
 
G

Govind

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change uppercase to proper case in entire worksheet? 7
How to change text in multiple cells from Uppercase to proper cas. 1
Automatically change text to uppercase 2
Change Upper Case to Proper Case 5
How can I apply a function (PROPER) to multiple cells at once? 3
Find the UPPERCASE letter in a string 9
How can I use one formula to change case on an entire worksheet? 2
Using PROPER for Columns, rows or ENTIRE spreadsheet 3

Top