| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to change the cell value if there is any word exist in that ce
Dear All,
I have worksheet and I want to change the values of all that cells which contain a specified word with any other word. e.g. A Ignition off GPS Ignition off Route Ignition off Time Ignition off Driving Excess Idle Start I want to change all the cell values to Ignition off if any cell contain Ignition off with any other word. To delete the other word and keep the Ignition off in cell. Thanks in Advance Hassan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change the cell value if there is any word exist in that ce
Just like MS Word, you use "Search and Replace" to accomplish the edit you
describe below. Simply highlight the column with the data and then locate your "Search and Replace" option. ("Search and Replace" is located in different places depending upon Excel version. Use HELP to locate it in your version if needed.) This is a very handy, re-usable skill (Search and Replacein Excel). I use it every week in the normal course of work. KIM W "Hassan" wrote: Dear All, I have worksheet and I want to change the values of all that cells which contain a specified word with any other word. e.g. A Ignition off GPS Ignition off Route Ignition off Time Ignition off Driving Excess Idle Start I want to change all the cell values to Ignition off if any cell contain Ignition off with any other word. To delete the other word and keep the Ignition off in cell. Thanks in Advance Hassan |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to change the cell value if there is any word exist in tha
Dear Kim,
I want formula to fit in macro, search and replace is not useful for me. Please give me any alternate. Thanks Hassan "KIM W" wrote: Just like MS Word, you use "Search and Replace" to accomplish the edit you describe below. Simply highlight the column with the data and then locate your "Search and Replace" option. ("Search and Replace" is located in different places depending upon Excel version. Use HELP to locate it in your version if needed.) This is a very handy, re-usable skill (Search and Replacein Excel). I use it every week in the normal course of work. KIM W "Hassan" wrote: Dear All, I have worksheet and I want to change the values of all that cells which contain a specified word with any other word. e.g. A Ignition off GPS Ignition off Route Ignition off Time Ignition off Driving Excess Idle Start I want to change all the cell values to Ignition off if any cell contain Ignition off with any other word. To delete the other word and keep the Ignition off in cell. Thanks in Advance Hassan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to change the background of a cell if I type a certain word | Excel Discussion (Misc queries) | |||
| change exist chart to be dynamic | Charts and Charting in Excel | |||
| I only want to change the formatting of one word in an Excel cell | Excel Discussion (Misc queries) | |||
| Does automatic change marks exist in Excel 97 | Excel Discussion (Misc queries) | |||
| If a cell is a certain word I would like it to change colors. | Excel Discussion (Misc queries) | |||
Linear Mode
