Excel never ceases to amaze me. It really is one of the best products that MS makes right up there with Onenote.

I had a problem at work where projects are coded with a letter at the end of their name that references which business line it is associated with. Without the need to code up some fancy VBA or reverse the text and use len(), I found that I can simply call the right() function to get the last letter.

People who looked at this item also looked at…

• How to Setup the Pocket PC for Getting Things Done (GTD)
• Speed Math Trainer
• Excel 2007 – How it Closed the Deal
• Put Every Bill in Congress on a Wiki
• One Excel Pivot Table Based Upon Another

Related items

• Automate Excel » Backup Del.icio.us with Excel
• One Excel Pivot Table Based Upon Another
• Excel 2007 – How it Closed the Deal
• R & Eclipse
• Save my MySQL?