If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
proper
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Ok I will try
|
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I use the "Proper" function? The instructions are vague. | Polly | Worksheet Functions | 5 | August 17th, 2005 07:51 PM |
Proper Case | Madhup Thakur | Using Forms | 3 | May 20th, 2005 12:10 PM |
Using PROPER for Columns, rows or ENTIRE spreadsheet | Tom | Worksheet Functions | 3 | February 4th, 2005 03:43 PM |
Proper case Help!! | Ian Brown | New Users | 4 | September 16th, 2004 12:27 AM |
Text Function Proper | Kelly | Worksheet Functions | 2 | February 18th, 2004 08:58 PM |