Current Challenge      Past Challenges
About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

 


Solve an Excel Challenge and WIN A PRIZE! Check out our challenge of the month and see what you can do! We periodically post a challenge to our Excel user community. Whoever successfully solves the problem wins a cool MrExcel.com prize and bragging rights! What more could you ask for?

 

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 to


Entry 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

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.