Trying to FIND Neutral Characters to do mass rename in EXCEL

[RudeBoy]

Ok for some reason when I run my Macros things get moved around in my Manual labels I created.

So to get around this I shut down all my formulas in my manual label sheets then rename em back in.

Easy solution. But lately I have been running into issues???

I am not sure if it is because of the equals sign =

Or the dollar Sign and now the Number sign?? #

Before in the beginning I would select the entire sheet and do the
following Replace

Replace this =IF
with $=

But I started having errors when I tried to rename the formulas back like this

Replace $=
with =IF

So I decided now to use the # sign..

So I simply do a
Replace =IF
with #=

BUT WHEN I TRY to DO a Rename Back like this
Replace #=
with =

I am receiving the Following ERROR:

The formula you typed contains an error.

For information on fixing this click help

Anyone have any ideas on this one- Thanks in Advance - Take Care

 

[RudeBoy]

Well looks like I found my own answer after playing around in her
The REPLACE needs to be

Replace #=
with =IF

That Works Thanks

 

[Peter_SSs]

Why include the IF in your initial Find/Replace?
Why not just replace = with #= then to undo, replace #= with =
That way it would work for all formulas, not only formulas that start with =IF