Delete cells with 0 as the tenth digit
On Sun, 08 Feb 2009 23:26:32 -0500, Ron Rosenfeld
wrote:
=RegexSub(A1,"(\n|^).{9}0.*","")
Minor change in the formula:
=RegexSub(A1,"(\n|^).{9}0.*(\n|$)","")
(The UDF remains the same, but the pattern in the formula needed a small
change).
--ron
|