My first question here. I have an Excel Spreadsheet, where I have not used CSE, which I import into Google Sheets. Upon importing, some 40k+ cells have =Array_Constrain(ArrayFormula(*),1,1)
in them. Except for two cells, in 1 sheet, across 50+ sheets, I do not need the formulas.
I spent over an hour, going sheet by sheet, to remove all "ArrayFormula". This left me with and extra set of () in the formulas, and I'm not looking forward to spending a few more hours removing all the Array_Constrains.
I'm wondering if someone can give me a CTRL+H and the RegEx expression to
- convert '=Array_Constrain((other_functions)),1,1)' to just '=other_functions' and for next time
- convert '=Array_Constrain(ArrayFormula(other_functions),1,1) to just '=other_functions'