Thanks all. This is really great help... and I learned something in
between. I understood everyone's post except Dana's. Dana, I'll have
to study your response (it's a little advanced for me at this point,
but I'll comprehend it soon). I didn't know about the 'With'
statement, but I do now. Also, I like the cleaned up versions
everyone supplied. I knew my code was cumbersome, I knew it could be
shortened - thanks to all for the suggestions.

My next trick is that I have 28 instances of this code. One for each
different 'flag' I have identified in my routine. They all do the
same logic, but write to different cells in my worksheet... meaning
each 'flag' (B D E J U or a combo I strip and seperate down) each gets
its own specific cell. i.e. - txt_ethy_flag equaling "B" is not the
same as txt_meth_flag equaling "B". My quest is to make this into a
sub function so that it gets ran when needed, and not repeated for
each of the 28 instances... suggestions?

-Tony