How do I find & replace text in formulas? Example, I would like to find and replace '2004' in a series of formulas to '2005'.
How do I find & replace text in formulas? Example, I would like to find and replace '2004' in a series of formulas to '2005'.
Simply use Edit | Find/Replace and make sure the Look in: box says Formulas
Find what: 2004
Replace with: 2005
HTH
Bruce
The older I get, the better I used to be.
USA
Hey Bruce!!
The answer to my find & replace in formulas question was so simple, yet I couldn't figure it out on my own.
Thanks loads for your prompt response. Now I can work faster...
Have a good weekend!!
Tisa
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks