Change case in excel

This query is : Resolved

R.DUTTA (Querist)
Follow

17 August 2011 Dear Experts,

I request for a small information and that is as belwo:
In Excel how to change a letter from capital letter to small in a particular cell or some cells.
Thanks and regards,
rd

Aditya Maheshwari

Aditya Maheshwari (Expert)
Follow

17 August 2011 EG. in case you have to shorten content of date in column C row 6 use formula in the next column =LOWER(C6)

In case you have to proper content of date in column C row 6 use formula in the next column =proper(C6)

R.DUTTA

R.DUTTA (Querist)
Follow

17 August 2011 Dear Mr. Aditya,
Thanking you very much for your answer. But I am not getting it properly.
Just think in column C and Row 6 I have typed small letter. Now I need to change in same cell(col 6 & row 6) from small to capital.
Kindly guide me.
Thanks and regards,
R.D

Upgrade to CAclubindia Pro. Subscribe Now!

Aditya Maheshwari

Aditya Maheshwari (Expert)
Follow

17 August 2011 small to capital - =upper(c6)