View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hassan Hassan is offline
external usenet poster
 
Posts: 75
Default How to change the cell value if there is any word exist in that ce

Dear All,

I have worksheet and I want to change the values of all that cells which
contain a specified word with any other word. e.g.

A
Ignition off
GPS Ignition off
Route Ignition off
Time Ignition off
Driving
Excess Idle
Start

I want to change all the cell values to Ignition off if any cell contain
Ignition off with any other word. To delete the other word and keep the
Ignition off in cell.

Thanks in Advance

Hassan