Dear Stefi,

Thanks for reply, following formula only remove Ignition off and other word
is still there, I want remove other word with Ignition off

Thanks

"Stefi" wrote:

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