Skip to main content

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
Labels:

Comments

Post a Comment

Popular posts from this blog

Password Protect your USB Flash Drive without any software....

I was trying to protect my USB flash drive from a long time but didn’t find anything nice. Almost all the software were either not giving full features or were asking for money to do so and give full benefits. One software called Truecrypt was nice but not giving me simple password protection feature. Anyways, now I submit one good info with all who want to simply password protect their USB flash drive / pen drive without all unnecessary softwares. Steps to protect your USB flash drive 1.       Insert your pendrive. 2.       Open the drive 3.       Create a folder (lets name is ABCD) and keep all your data in it. (You can partially protect this disk too by moving your important / secure data only into this folder) 4.       Remember a password. Lets name is 12345 5.       Now open a note pad and copy and paste the following text into it: -...
10 comments
Read more

Difference Between Consignment And Sales

Consignment can not be treated as sales of goods. It is different from sales. The difference between consignment and sales are as follows: 1. Ownership Consignment: The ownership of the goods remains with the consignor until sales is effected by the consignee. Sales: The ownership of the goods immediately transferred to the buyer when sale is effected. 2. Relationship Consignment: The relationship between the consignor and consignee are of principal and agent. Their relation ship are continued till terminated. Sales: The relationship between the two parties are that of seller and buyer and they terminated as soon as payment is made and goods are delivered. 3. Expenses Consignment: The expenses incurred by the consignee to execute sale and the expenses incurred by consignor to send the goods to the consignee, both are borne by the consignor. Sales: Any expenses incurred after the sale is not borne by the seller. 4. Risk Consignment: The risk of goods under c...
8 comments
Read more

Sai Sampurna Padhi - A Sweet Bubbly Girl fighting for her life at Cuttack

Hello Everyone, Today I want to share with you all about a girl named "Sai Sampurna Padhi" Some details of this girl: - Name                   : - Sai Sampurna Padhi Age                       : - 2.5 Years Residence           : - Bidanasi, Cuttack, Odisha Father's Name    : - Linku Padhi Mother's Name   : - Chandrika Mohapatra Father's Occupation    : - Auto Driver at Badambadi Bus Stand, Cuttack This girl is admitted to SCB Medical College because she is suffering from a very dangerous disease called "Blood Cancer" and as its at Stage-I doctors has prescribed to go for Bone Marrow transplant as soon as possible so that this can be cured. But the operation cost around 20-25 Lacks which they can't arrange. For the time being, every week she has need of blood, plasma, test & medicine which is less as it is a government ho...
Post a Comment
Read more