Convert excel contents into lower and upper case.

Its very easy to convert excel data into lower and upper cases.

For changing into lowercase, use formula

                                 =LOWER(A1),  where A1 is the corresponding column name.

For changing into uppercase, use formula
           
                              =UPPER(A1)


 =PROPER(A1) function can be used and gives result same as column D(Refer image attached)