find and replace

[myguess21]

I have situation where I need to find a number and replace with string. Currently I do it manually, was hopping if this can be done programmatically. Sorry don’t know how to do that, if someone can please help me.
These are the steps I do:
1. open excel
2. go to a tab
3. CTRL + H
4. Put my number “4”
5. Replace string “ stopped”
6. Click OK
Repeat for following:
1 = good
2 = running
3 = canceled
4 = stopped

[arlu1201]

Are these the only 4 conditions you have?
1 = good
2 = running
3 = canceled
4 = stopped

[myguess21]

at this time Yes. so I want to replace 1 with good and so on..

[arlu1201]

Ok, do you want this to be done in each sheet of the workbook?

In which column should the find replace be done?

[myguess21]

"sheet 1" and Column " F "

[arlu1201]

Try this

Please Login or Register  to view this content.

[myguess21]

Thanks. This works!