Excel Macro Find and Replace, Nested loop?

[theandrewgordon]

I have found something rather annoying with excel. Running index match to file in a table. Then the table populates lots of formulas. At the moment it has statements like:
IF(ISBLANK(B93),0 etc. but I need to expand its ability to account for every form of blank/0/"". I need to do a find and replace that says for all cells on worksheet 'main', sometimes multiple times in some cells.
sample of what I would replace with if(OR($B93=0,0<COUNTBLANK($B93)))

If isblank(*2-5char*) replace with or(*2-5char*=0,0<countblank(2-5char*))

I would think the solution would be:
Find first instance of isblank, find first following), store from end of isblank to ), write stored into formula listed above....

Thoughts? A good way to do this and loop through all instances of this?

Ps. Here's one of the reasons I would possibly need it a couple times in a cell.
=IF(OR(ISBLANK(B37),ISBLANK(B38),ISBLANK(B39)),"N",IF($B$36="Y","R"&C38&C37 ,C39&C38&C37))


Thank you for your assistance.

 

[theandrewgordon]

I am thinking I would need to use a RegEx statement....