On Mon, 9 Feb 2009 00:42:33 -0500, "Rick Rothstein"
wrote:

I think you will have to modify that pattern a little more... it seems to
kill off the internal newline character for this text...

Thanks for pointing that out.

The following seems to work on all the examples:

=RegexSub(A1,"^.{9}0.*$[\n\r]","")

--ron