Difference between revisions of "Manuals/calci/UPPER"

From ZCubes Wiki
Jump to navigation Jump to search
Line 21: Line 21:
  
 
==References==
 
==References==
 
 
 
<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''UPPER'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">(</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">'''txt'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">)</font></font></font>
 
 
<font color="#484848"><font face="Arial, sans-serif"><font size="2">'''where txt'''</font></font></font><font color="#484848"><font face="Arial, sans-serif"><font size="2">   is the text that is converted to uppercase. </font></font></font>
 
 
</div>
 
----
 
<div id="1SpaceContent" class="zcontent" align="left">
 
 
<font color="#000000">  </font>
 
 
<font color="#484848"><font face="Arial, sans-serif"><font size="2">It converts text to uppercase.</font></font></font>
 
 
</div>
 
----
 
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
 
 
UPPER
 
 
</div></div>
 
----
 
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
----
 
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
----
 
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
----
 
<div id="4SpaceContent" class="zcontent" align="left"><div>
 
 
{| id="TABLE1" class="SpreadSheet blue"
 
|- class="even"
 
| class=" " |
 
| class=" " | Column1
 
| class="          " | Column2
 
| class="    " | Column3
 
|- class="odd"
 
| class=" " | Row1
 
| class="sshl_f " | word
 
| class="sshl_f" | WORD
 
| class="sshl_f" |
 
|- class="even"
 
| class="  " | Row2
 
| class="sshl_f" |
 
| class="sshl_f SelectTD SelectTD" |
 
| class="sshl_f" |
 
|- class="odd"
 
| class="sshl_f" | Row3
 
| class="sshl_f" |
 
| class="  " |
 
| class="sshl_f" |
 
|- class="even"
 
| class="sshl_f" | Row4
 
| class="sshl_f" |
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|- class="odd"
 
| class="sshl_f" | Row5
 
| class="sshl_f" |
 
| class="sshl_f" |
 
|
 
|}
 
 
<div align="left"></div>''''''</div></div>
 
----
 
<div id="2SpaceContent" class="zcontent" align="left"> 
 
 
<font color="#484848"><font face="Arial, sans-serif"><font size="2">Let’s see an example in (Column1 Row 1)</font></font></font>
 
 
[javascript:ToggleDiv('divExpCollAsst_4') <font color="#666666"><font face="Arial, sans-serif"><font size="2">C1R1 = word</font></font></font>]
 
 
[javascript:ToggleDiv('divExpCollAsst_4') <font color="#666666"><font face="Arial, sans-serif"><font size="2">I.e=UPPER(C1R1) is WORD</font></font></font>]
 
 
</div>
 
----
 

Revision as of 01:29, 23 December 2013

UPPER(txt)


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

Description

  • This function used to change the lower case letters in to upper case letters.
  • Upper case letters are the alphabetical capital letters and Lower case are the alphbetical small letters.
  • Capital letters:ABCDEF…..,Small letters:abcdef….
  • UPPER 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

  • UPPER("total marks")=TOTAL MARKS
  • UPPER("United Kingdom")=UNITED KINGDOM
  • UPPER("Register no is 2347")=REGISTER NO IS 2347
  • UPPER("address:#83,salai street")=ADDRESS:#83, SALAI STREET
  • UPPER(cool)=Null

See Also

References