| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
