Excel 2007 Formulas (Mr. Spreadsheets Bookshelf)
Excel has many functions that work with text, but you're likely to run into a situation in which the appropriate function just doesn't exist. In such a case, you can often create your own worksheet function using VBA.
| Cross Ref | Chapter 25 contains a number of custom text functions written in VBA. |