i use find and replace quite a bit, I've got about 200 formulas, which just for example are in the format:
=name1*name2
i want to do a replace, changing all "*" for "-" so they are now subtracting from each other..
my problem is ofcourse that * is a wildcard. Does anyone know how to overcome this?
from my previous life in programming I'm sure I used / or \ to stop it working but this doesn't seem to work.
please help! thanks in advance Brian
=name1*name2
i want to do a replace, changing all "*" for "-" so they are now subtracting from each other..
my problem is ofcourse that * is a wildcard. Does anyone know how to overcome this?
from my previous life in programming I'm sure I used / or \ to stop it working but this doesn't seem to work.
please help! thanks in advance Brian