| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Require help with PROPER function in excel
I faced that PROPER function does not convert text properly. FOr example,
Your text is: ThIs IS a rAbbIt. It will convert like this: This Is A Rabbit. If you notice, it sets all first letter after every space in upper case. If you look at the proper sentence, it should look like this - -- This is a rabbit. Please help me with solution. Thanks, praveen add on fb - royalstone.r |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formulas/function require (2) | Excel Worksheet Functions | |||
| CountIf Function - require range of criterea | Excel Worksheet Functions | |||
| "proper" function excel wksht | Excel Worksheet Functions | |||
| PROPER function | Excel Worksheet Functions | |||
| How do I use the PROPER function? | Excel Discussion (Misc queries) | |||
Threaded Mode
