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

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

Ok I will try

David:

Thank u.

I am relatively new to macros.I did as follows

I went to VB editor insert modulepasted what you sent and closed VB
editor,then followed ur instructions for the short cut key.
Did I do it right.David can u direct me to some site to learn macros

AFD