writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''PROPER'''</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 text enclosed in quotation marks that want to partially capitalize.</font></font></font>+ + + + + + − </div>+ − ----+ − <div id="1SpaceContent" class="zcontent" align="left">+ + + − <font color="#484848"><font face="Arial, sans-serif"><font size="2">It capitalizes the first letter in a text string </font></font></font>+ + + − </div>+ − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − PROPER − − </div></div> − ---- − <div id="8SpaceContent" 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> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">C1R1 = a bird is flying</font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">I.e.=PROPER(C1R1) is </font></font></font> − − <font color="#484848"><font face="Arial, sans-serif"><font size="2">A Bird Is Flying</font></font></font> − − </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="2SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | Column1 − | class=" " | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f " | a bird is flying − | class="sshl_f" | A Bird Is Flying − | − | class=" sshl_f " | − |- class="even" − | class=" " | Row2 − | class="sshl_f" | − | class="sshl_f SelectTD SelectTD" | − <div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − | − | − |- class="odd" − | Row3 − | class=" sshl_f " | − | − | − | − |- class="even" − | Row4 − | − | − | − | class=" " | − |- class="odd" − | class=" " | Row5 − | − | − | − | − |- class="even" − | Row6 − | − | − | − | − |} − − <div align="left">[[Image:calci1.gif]]</div></div> − ----
no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''PROPER(txt)'''</div><br/>
*<math>txt</math> 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==
#PROPER("i like to have a icecream")=I Like To Have A Icecream.
#PROPER("WHERE YOU ARE GOING")=Where You Are Going.
#PROPER("august 15th")=August 15Th.
#PROPER(nice place)=Null
==See Also==
*[[Manuals/calci/UPPER | UPPER ]]
*[[Manuals/calci/LOWER | LOWER ]]
==References==