Find and replace, leaving part of the cell untouched

Hello, this is my first post here.

I am trying to add an IFERROR to all of the cells that start with QUARTILE in a sheet. There are a bunch of errors I want to delete, and they are affecting the quartile cells (which I want to keep). This will allow me to use goto->errors->delete to delete the rest of the errors.

The way I was thinking was to find and replace with ** where the cells differ, but that doesn't seem to work.
Find: QUARTILE.EXC(**:**,*)
Replace: IFERROR(QUARTILE.EXC(**:**,*),0)
Doesn't work.

Any ideas?

Hi, welcome to the forum

If you cant do this by changing the 1st cell andthen copying down, try this 3-step approach...

1. Find =Quartile Replace with @@IFERROR(QUARTILE
2. Find ) Replace with ),"")
3. Find @@ Replace with =

OK so adjust step 2 to suite, or add extra steps

Sometimes simple (and crude) is the quicker way to go