[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: RE: Request
Arnold Levinson wrote
> 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
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.
Text is text enclosed in quotation marks, a formula that returns text, or
reference to a cell containing the text you want to partially capitalize.
PROPER("this is a TITLE") equals "This Is A Title"
PROPER("2-cent's worth") equals "2-Cent'S Worth"
PROPER("76BudGet") equals "76Budget"
* For searches and help try:
- st: Request
- From: "Arnold Levinson" <email@example.com>