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