Manuals/calci/PROPER - Revision history

Devika at 21:24, 13 August 2018

2018-08-13T21:24:50Z

2017-03-14T11:47:25Z

2015-07-19T19:10:22Z

2015-06-03T19:07:34Z

ZOS Section

2015-05-14T19:27:49Z

References

2014-06-30T09:10:10Z

2013-12-26T09:23:10Z

2013-12-26T09:20:37Z

Description

2013-12-23T07:43:49Z

2013-12-23T07:42:42Z

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''PROPER(text)'''</div><br/>
+<div style="font-size:30px">'''PROPER (String) '''</div><br/>
-*<math>text</math>  is the text  given in double quotes
+*<math>String</math>  is the text  given in double quotes.
 ==Description==
@@ Line 7: / Line 8: @@
 *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 <math>txt</math> with in double quotes("") or we can use the cell references.
+*Also we have to give the <math>String</math> with in double quotes("") or we can use the cell references.
 ==ZOS==
-*The syntax of displaying the text in a proper method in ZOS is <math>PROPER(text)</math>.
+*The syntax of displaying the text in a proper method in ZOS is <math>PROPER(String)</math>.
-**<math>text</math>  is the text  given in double quotes.
+**<math>String</math>  is the text  given in double quotes.
 *For e.g.,

← Older revision		Revision as of 11:47, 14 March 2017
Line 30:		Line 30:
	==References==		==References==
	*[http://www.techonthenet.com/excel/formulas/proper.php Proper]		*[http://www.techonthenet.com/excel/formulas/proper.php Proper]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 19: / Line 19: @@
 #PROPER("august 15th")=August 15Th.
 #PROPER(nice place)=Null
 ==See Also==

@@ Line 9: / Line 9: @@
 *Also we have to give the <math>txt</math> with in double quotes("") or we can use the cell references.
-==ZOS Section==
+==ZOS==
 *The syntax of displaying the text in a proper method in ZOS is <math>PROPER(text)</math>.
 **<math>text</math>  is the text  given in double quotes.

← Older revision		Revision as of 19:27, 14 May 2015
Line 25:		Line 25:

	==References==		==References==
		+	*[http://www.techonthenet.com/excel/formulas/proper.php Proper]

@@ Line 8: / Line 8: @@
 *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 txt with in double quotas("") or we can use the cell references.
+*Also we have to give the <math>txt</math> with in double quotas("") or we can use the cell references.
 ==Examples==

@@ Line 6: / Line 6: @@
 *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.
+*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 txt with in double quotas("") or we can use the cell references.

← Older revision		Revision as of 07:42, 23 December 2013
Line 1:		Line 1:
	<div style="font-size:30px">'''PROPER(txt)'''</div><br/>		<div style="font-size:30px">'''PROPER(txt)'''</div><br/>
−	*<math>txt</math> ~~txt~~ is the text given in double quotas	+	*<math>txt</math> is the text given in double quotas