This assumes that "ignition off" and "startup" are *not* in the same cell:

=IF(COUNTIF(A1,"*ignition off"),"Ignition
off",IF(COUNTIF(A1,"*startup*"),"startup",A1))

Copy down as needed.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"TFMR" wrote in message
...
Thanks Ragdyer,

Can I use two statuses instead of one, e.g. Ignition off and Startup as
well.

Thanks

Hassan

"Ragdyer" wrote:

To save everyone the necessity of continued *guessing* at exactly what
you're looking for, would you at least extend us all the courtesy of
informing us as to what didn't work?

What did you get that you didn't want,
OR
what didn't you get that you wanted!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Hassan" wrote in message
...
Thanks for reply Ragdyer, but following is not working.

"Ragdyer" wrote:

Does this work for you:

=IF(COUNTIF(A1,"*ignition off")0,"Ignition off",A1)
?
Copy down as needed.
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit
!

--------------------------------------------------------------------------
-
"Hassan" wrote in message
...
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