How to change cell value if cell contain specified word
Yes Stefi, Exactly same.
"Stefi" wrote:
Do you mean that cells containing Ignition off should change to mere Ignition
off and all other words should be removed?
E.g.
Old content new content
GPS Ignition off Ignition off
Unlock Ignition off Ignition off
Health check Ignition off Ignition off
GPS Unlock Ignition off Ignition off
Stefi
€˛Hassan€¯ ezt Ć*rta:
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
|