writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 6:
Line 6: − +
no edit summary
*This function is used to capitalizes the first letter in each word .
*This function is used to capitalizes the first letter in each word .
*Also it is changing the other letters in to lower case.
*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.
*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 txt with in double quotas("") or we can use the cell references.