| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Correct Text Case to PROPER capitalization
How do I correct the text case of data that is in ALL CAPS to PROPER
capitalization form. |
|
#2
|
|||
|
|||
|
One way, =PROPER(A1) and copy down
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halljlsampeck" wrote in message ... How do I correct the text case of data that is in ALL CAPS to PROPER capitalization form. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Amount or Numbers in Words | New Users to Excel | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Spellnumber | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Linear Mode
