I just found this when trying to see if a "Search for text in formula" feature request had been put in. I NEED this :)
-Neil
@Shonnify You said:
"The formulas, or find and replace options do not work well with hidden, closed or indented formats. We also need an "expand all" option to help with this. Otherwise, you have to open each + separately."
If you right click on the Primary Column header, there should be an option to "Expand All" which I believe is exactly what you are looking for in that particular comment…
Having the ability to find and replace items in formulas would be incredibly helpful and save time as we update certain sheets each year.
THIS WOULD SAVE ME HOURRRRRRRSSSSS!!!!!!!!!!
This would save me hours and hours. I have multiple formulas where the formula structure is the same but the filter criteria is the only thing different. Being able to find & replace that criteria would be incredible.