New answers tagged regex
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
🔲 ...
- 6,488
Top 50 recent answers are included