New answers tagged

1 vote
Accepted

Remove all Array_Constrain(ArrayForumla(*),1,1) formulas when importing from Excel to Google Sheets using RegEx

To get started, choose Edit > Find and replace (Control+Shift+H) and use something like this: Find: =ARRAY_CONSTRAIN\(\s*ARRAYFORMULA\(\s*(.+)\s*\), 1, 1\) Replace with: =$1 Search: All sheets 🔲  ...
user avatar
  • 6,488

Top 50 recent answers are included