You can't change a cell value by a formula. Yu can use a helper column with a
formula in it returning the required result:
=TRIM(SUBSTITUTE(A1,"Ignition off",""))

Regards,
Stefi


€žHassan€� ezt Ã*rta:

Dear All,

I am looking for a formula that will change all the cells value if that
contains the specified word. e.g.

GPS Ignition off
Unlock Ignition off
Health check Ignition off
GPS Unlock Ignition off

if a cell contains Ignition off then cell value should change with Ignition
off and remove the other status with Ignition off.

Thanks