Always nice to be appreciated, ChrisOK. One thing I don't understand: I suggested (twice) that it might be simpler to use a single formula, using not the MID function but RIGHT and LEFT. You could put that formula in column K, omit the table of formula entirely and not have to write or use any VBA program. Did you have some reason not to want to use that solution, or did you just not see it (twice)?
|