| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
capital letters to lowercase
I have a list of proper nouns (names, addresses, ect.) that is in all capital
letters, I am looking for a formula that would capitalize the first letter of each word and make the rest of the letters in the word lowercase. example: JOHN SMITH 123 MAPLE LN would become: John Smith 123 Maple Ln any help would be greatly apprecitated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing capital letters | Excel Discussion (Misc queries) | |||
| Excel Capital Letters | Excel Discussion (Misc queries) | |||
| Capital Letters Only | Excel Discussion (Misc queries) | |||
| Capital Letters | Excel Worksheet Functions | |||
| Auto change font to 'capital letters' | Excel Worksheet Functions | |||
Threaded Mode
