how to use wildcards in search/replace for existing formulas?

For some reason I'm having trouble using wildcards in the find/replace function.

In the attached workbook, I want to nest the existing formulas beginning in cell U10 down and to the right within an

Please Login or Register  to view this content.

fix so that cells with errors will be blank.

All of the formulas have the same construction but which contain different cell references. (the actual workbook has around 50,000 cells with this formula construction).

According to the official MS documentation, Find/Replace is supposed to accept the asterisk wildcard for strings with multiple characters, but I haven't had success making this work.

I'm sure the solution is obvious, but... for now, not for me!

Thanks

PS it won't matter to me if the find/replace attempts to wrap other formulas within the worksheet within the IFERROR function. I can fix these rather easily.

Hi - So you just want to edit your formulas so if the result is false you want a blank cell? If so, take a look at U10 in my file.

Am not understanding why you need find/replace.

Sorry for being so late to respond. Bo your formula works, but my workbook is pretty large (over 2 million cells) and I'm trying to avoid functions like vlookup, index, etc. They slow it down (which ordinarily wouldn't be an issue, but I also use Solver to go through lots of iterations in cell $U$1, so I was hoping to just find a simple method of altering my own formula using search/replace. Microsoft's method, here: https://support.microsoft.com/en-us/...f-fdb42f892e90


I couldn't get that to work, so I wound up just manually nesting my existing formulas in the iferror function, then copying down.


But thanks for your help. I'll keep your solution in mind for future work.