Hi Steve,
Thanks for the code and help and it worked for replacing DATA with
!DATA (preceded by an exclamation mark)

But I have a slight problem...I wish to replace "" (double quotes)
with "NA" used in an IF formula to display Blank or NA...then I
cannot do it

I tried to replace "i" with """" and "z" with
"NA"... I did not succeed

I wish to replace double quotes ("") with "NA" (NA with double
quotes)

Any idea?

Thanks again
Rashid