Dear Amit Insa
i wil provide some info. wich may help u.
---There are two methods you can use to change existing cell values to upper, lower, or proper case. The first method is to use a formula to change the case. The second method is to use a VBA procedure.
To change case with a formula, insert a blank column next to the column whose case you wish to change. In that column enter one of the following formulas, depending on what case you want as the result. Change the reference A1 to the first cell in your range.
=UPPER(A1)
=LOWER(A1)
=PROPER(A1)
Next, fill this formula down in the new column as far as you need to go to convert all your cells. Finally, copy the new column, select the first cell in the original range, A1 in this example, and choose Paste Special from the Edit menu. In that dialog, choose the Values item in the Paste options. You can now delete column you added. Note that this method should not be used if your original range has formulas in it. The paste operation will overwrite any existing formulas with static text values.
thsi is hw u can change capital into small letters.
Regrds
Sen!!!!!!!!