The Excel Formula : TRIM, UPPER, LOWER & PROPER

Dear Friends,

Please find some useful formula for MS Excel. You can learn them, try them and apply them when you need them. If your database is huge then these are very useful to get the output easily in seconds.

TRIM
	ColC	ColD
Row3	Original Text	Trimmed Text
Row4	kuna	kuna	=TRIM(C4)
Row5	k    u   n   a	k u n a	=TRIM(C5)
Row6	kuna             meher	kuna meher	=TRIM(C6)
Row7	kuna	kuna	=TRIM(C7)
	What the use of this function / formula?
	This function removes unwanted spaces from a piece of text.
	The spaces before and after the text will be removed completely.
	Multiple spaces within the text will be trimmed to a single space
	Formula Syntax
	=TRIM(TextToTrim)
	Formatting
	No special formatting is needed.

LOWER
	ColC	ColD
Row3	Upper Case Text	Lower Case
Row4	kuna meher	kuna meher	=LOWER(C4)
Row5	LITU GARNAIK	litu garnaik	=LOWER(C5)
Row6	RAJENDRA BEHERA	rajendra behera	=LOWER(C6)
Row7	NAVEen sharma	naveen sharma	=LOWER(C7)
Row8	navEEN123	naveen123	=LOWER(C8)
	What the use of this function / formula?
	This function converts all characters in a piece of text to lower case.
	Formula Syntax
	=LOWER(TextToConvert)
	Formatting
	No special formatting is needed.

UPPER
	ColC	ColD
Row3	Original Text	Upper Case
Row4	kuna meher	KUNA MEHER	=UPPER(C4)
Row5	LITU GARNAIK	LITU GARNAIK	=UPPER(C5)
Row6	rAJENDRA beHERA	RAJENDRA BEHERA	=UPPER(C6)
Row7	NAVEen sharma	NAVEEN SHARMA	=UPPER(C7)
Row8	navEEN123	NAVEEN123	=UPPER(C8)
	What the use of this function / formula?
	This function converts all characters in a piece of text to upper case.
	Formula Syntax
	=UPPER(TextToConvert)
	Formatting
	No special formatting is needed.
	Example
	See the example for FREQUENCY.

PROPER
	ColC	ColD
Row3	Original Text	Proper
Row4	kuna meher	Kuna Meher	=PROPER(C4)
Row5	LITU GARNAIK	Litu Garnaik	=PROPER(C5)
Row6	rAJENDRA beHERA	Rajendra Behera	=PROPER(C6)
Row7	NAVEen sharma	Naveen Sharma	=PROPER(C7)
Row8	navEEN123	Naveen123	=PROPER(C8)
	What the use of this function / formula?
	This function converts the first letter of each word to uppercase, and all subsequent letters
	are converted to lower case. Useful when you have a database in which the data
	has been entered without taking care of upper and lower cases.
	Formula Syntax
	=PROPER(TextToConvert)
	Formatting
	No special formatting is needed.

For any query on these formulas ,you can mail me at sharma.ctc@gmail.com