Enter this into a macro:

Sub changeToProper()
ActiveCell.Value = Excel.WorksheetFunction.Proper(ActiveCell.Value)
End Sub

Then, on your spreadsheet, go Tools-Macro-Macros, select "changeToProper",
select "Options" and enter the keyboard shortcut you would like.


--
Regards,
Dave


"afdmello" wrote:

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