proper

[afdmello]

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 copy>paste special >values only to the required cell.Then got the
answer cell and clear contents.

AFD

 

[Guest]

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.

 

[afdmello]

Ok I will try

 

[afdmello]

David:

Thank u.

I am relatively new to macros.I did as follows

I went to VB editor >insert module>pasted 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