Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert numbers to text | Excel Discussion (Misc queries) | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |