View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 2
Default Need Help Editing Cells

I am using W XP and Excel 2003. I have an XLS file that was created
from a CSV file. Column D of the Xls file containd a great deal of data
that is still comma seperated. For example a row may have Ford, Chevy,
Dodge... Another row in the same column may have Dodge, Honda,
Toyota...

What I want to do is delete the contents of any cell in Column D that
does not contain Honda. Any cell that does contain Honda should have
any other data deleted except for Honda.

Thanks for any and all help.