Custom VBA Text Functions

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.