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.