Manuals/calci/PROPER

From ZCubes Wiki
Revision as of 03:20, 26 December 2013 by Abin (talk | contribs) (→‎Description)
Jump to navigation Jump to search
PROPER(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 is 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 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

References

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/PROPER&oldid=196820"