| Current Challenge Past Challenges |
 |
 |
| About MrExcel |
| Consulting Services |
| Learn Excel Resources |
| Challenge of the Month |
| MrExcel Seminars |
| MrExcel Store |
| Podcast |
| Search |
| Media |
| Contact |
| Home |
 |
 |
|
Following the style of the last few challenges, the April 2003 challenge is to submit the most useful general purpose utility for Excel. This can be anything that you wrote to improve your efficiency with Excel. Ideally, it would be something with broad applicability to many people.
Submit your entries as soon as possible, and before April 30, 2003. All entries will be posted here every few weeks and the winner will be decided by a vote of MrExcel readers. The winner will receive a copy of MrExcel ON EXCEL or any other book/CD from Holy Macro! Books. You can discuss your favorite entries in the lounge, or e-mail them toEntry 1:
Apply Formula to Range Utility by Graham Drummond
Graham writes, I always needed to be able to apply a certain formula to every cell in a selected range, e.g. convert a bunch of numbers from hex to decimal, etc. You first select the cells you wish to change, and then run the macro. The above dialog box pops up. Type in the formula you want to apply to the selected cells, using the @ character to denote the original value of the cell. If the original cell was a text format, then you might need to enclose the @ character in quotes. You can perform some cool text functions such as changing names from "Smith, Alan" format to "Alan Smith" by putting in the following function like this:
RIGHT("@",LEN("@")-SEARCH(", ","@")-1) & " " & LEFT("@",SEARCH(", ","@")-1)
Back to top