Sharing some useful tips, solutions and notes for Geeks.

Tuesday, July 30, 2013

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)


No comments: