just suppose a cell is having text in caps and I want to convert it to
proper.How can I do so with only one keystroke: a macro maybe.

Now I do it like this:
select a blank cell use the proper formula and get the answer in the blank
cell.Then copypaste special values only to the required cell.Then got the
answer cell and clear contents.

AFD