| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to change cell value if cell contain specified word
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to change cell value if cell contain specified word
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to change cell value if cell contain specified word
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to change cell value if cell contain specified word
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to change cell value if cell contain specified word
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the cell value if there is any word exist in that ce | Excel Discussion (Misc queries) | |||
| Trying to change the background of a cell if I type a certain word | New Users to Excel | |||
| Trying to change the background of a cell if I type a certain word | Excel Discussion (Misc queries) | |||
| I only want to change the formatting of one word in an Excel cell | Excel Discussion (Misc queries) | |||
| If a cell is a certain word I would like it to change colors. | Excel Discussion (Misc queries) | |||
Hybrid Mode
