Oops, upon a closer 2nd reading of your lines ..
.. What I want to do is delete the contents of any cell in Column D that
does not contain Honda...

Instead of:
Put in X2:
=IF(TRIM(D2)="","",IF(COUNTIF(D2,"*Honda*"),"Honda ",D2))

It should just be in X2, copied down:
=IF(TRIM(D2)="","",IF(COUNTIF(D2,"*Honda*"),"Honda ",""))

(The former simply returns the contents of col D where "Honda" is not found)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---