Difference between revisions of "Manuals/calci/LOWERCASE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div style="font-size:30px">'''LOWERCASE(text)'''</div><br/> *<math>text</math> is the text which we want change in to a lowercase. ==Description== *This function used to ch...")
 
 
Line 1: Line 1:
<div style="font-size:30px">'''LOWERCASE(text)'''</div><br/>
+
<div style="font-size:30px">'''LOWERCASE(String)'''</div><br/>
*<math>text</math> is the text which we want change in to a lowercase.  
+
*<math>String</math> is the text which we want change in to a lowercase.  
  
 
==Description==
 
==Description==
Line 15: Line 15:
 
*LOWERCASE("Time %")=time %
 
*LOWERCASE("Time %")=time %
 
*LOWERCASE(Small)=Null
 
*LOWERCASE(Small)=Null
 +
 +
==Related videos==
 +
 +
{{#ev:youtube|kHVQqbZk8oI|280|center|LOWER}}
 +
 +
==See Also==
 +
*[[Manuals/calci/UPPER  | UPPER ]]
 +
*[[Manuals/calci/PROPER  | PROPER ]]
 +
 +
==References==
 +
[http://en.wikipedia.org/wiki/Letter_case  Letter case]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 14:29, 5 April 2018

LOWERCASE(String)


  • is the text which we want change in to a lowercase.

Description

  • This function used to change the upper case letters in to lower case letters.
  • Upper case letters are the alphabetical capital letters and Lower case are the alphabetical small letters.
  • Capital letters: ABCDEF…..,Small letters: abcdef…. LOWER 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 text with in double quotes("") or we can use the cell references.

Examples

  • LOWERCASE("WONDERFUL")=wonderful
  • LOWERCASE("United Arab Emirates")=united arab emirates
  • LOWERCASE("Train No is 16245")=train no is 16245
  • LOWERCASE("Time %")=time %
  • LOWERCASE(Small)=Null

Related videos

LOWER

See Also

References

Letter case