In my Col-A I have the below formula copied down 10,000 rows
I get either 1-1234 or "" (zero-strings) as a result.

I want to repeat the occasional change in the numbers 1-1234 (row 10)
and 1-2222 (Row1200) to OVERRIDE the zero-strings. How can this be done

I thought of using Special Cells Blank - but such of course doesn't work to
select the zero-strings as they ARE NOT BLank.

Any help appreciated on this..


=IF(MID(C12,2,1)="-",C12,"")