Manuals/calci/PROPER

PROPER(txt)

• $txt$ txt is the text given in double quotas

Description

• This function is used to capitalizes the first letter in each word .
• Also it is changing the other letters in to lower case.
• In a sentence this function taking the first letter of each word to change in to a upper case letters and remaining all of the letters it will change in to a lower case letters.
• PROPER function will consider only the text, when we are giving any numbers, or any special characters like @,&.. all are ignored.
• Also we have to give the txt with in double quotas("") or we can use the cell references.

Examples

1. PROPER("i like to have a icecream")=I Like To Have A Icecream.
2. PROPER("WHERE YOU ARE GOING")=Where You Are Going.
3. PROPER("august 15th")=August 15Th.
4. PROPER(nice place)=Null

See Also

• UPPER
• LOWER