| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Proper" string function
Is there a function in VBA that is equal to the Proper function in excel? I know there is a Ucase and a Lcase...
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Proper" string function
George,
Use the StrConv function. E.g., Result = StrConv(Text, vbProperCase) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "George" wrote in message ... Is there a function in VBA that is equal to the Proper function in excel? I know there is a Ucase and a Lcase... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Proper" string function
Thanks Chip!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| =SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | Excel Worksheet Functions | |||
| Converting "uppercase" string data to "lower case" in CSV file | Excel Discussion (Misc queries) | |||
| text string: "91E10" in csv file auto converts to: "9.10E+11" | Excel Discussion (Misc queries) | |||
| Insert "Proper Function" into existing macro | Excel Worksheet Functions | |||
![George[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
