Excel - Search and Replace Inverted Commas

So, the issue seems to be quite trivial, but I cannot find a solution. Pretty much, I have the following formula:

=IfError(1/0;"MyError")

And I want to change "MyError" to set_error_str using the excel Search and Replace option.

What I have tried:

  1. plenty of escape inverted commas (I tried with up to 4);
  2. CHAR(34);

Note - I am aware how to do it with VBA, but I want a normal user solution with Search and Replace (Ctrl+H). And in the net I found plenty of examples for SUBSTITUTE formula, but this is also not what I want.

Answers


This is what worked for me.

  • In the find box enter "MyError" (with the quotes)
  • In the replace box enter: set_error_str
  • Expand the options and make sure that the Look in is set to Formulas

Now it should work


I'm failing to see the problem. [Ctrl]+H, search for "MyError"), replace with set_error_str).

                                before Find and Replace

                                after Find and Replace


Need Your Help

Separating double according to "." in java

java split double

i have a double number which is "547.123456"

MoPub install AdMob via CocoaPods

admob cocoapods mopub

I attempted to install AdMob support via cocoapods with the following podfile: