Wild Card help

[jtk911]

Version: 2007

Need to find a replace the following:
Find '=+'
Replace =+'

It is not finding the formula (written as text).
I am trying to replace the single quote with nothing so it becomes a formula again.

I thought the tilda placed before it would help find it but that didnt' work.
Of course F1 was useless in this version.
I remember there was some special character in v2003 but can't find it in v2007 help.

Can someone please help with this?

 

[jtk911]

You can select the range of interest, and in the VBE Immediate window enter

Selection.Value = Selection.Formula

I found the VBE Immediate Window.
It worked great and I was able to group everything and replace at once.

Love this site - pure genius.

 

[shg]

You're welcome, glad it worked for you.