Arnold Levinson wrote
>
> Statamakers,
> Could -- proper -- or -- title -- be added to the string functions? (Excel
> provides this feature, it's very useful for name/address data.)
For those who like myself would need to look this up, this is Excel's
PROPER():
PROPER
Capitalizes the first letter in a text string and any other letters in text
that follow any character other than a letter.
Converts all other letters to lowercase letters.
Syntax
PROPER(text)
Text is text enclosed in quotation marks, a formula that returns text, or
a
reference to a cell containing the text you want to partially capitalize.
Examples
PROPER("this is a TITLE") equals "This Is A Title"
PROPER("2-cent's worth") equals "2-Cent'S Worth"
PROPER("76BudGet") equals "76Budget"
Nick
[email protected]
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
