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
🔲 ...
Top 50 recent answers are included
Related Tags
regex × 164google-sheets × 137
formulas × 87
google-sheets-arrayformula × 61
google-sheets-query × 35
regexextract × 17
google-apps-script × 8
concatenate × 8
conditional-formatting × 7
filter × 6
google-docs × 5
google-search × 5
search × 5
google-sheets-dates × 5
google-forms × 4
vlookup × 4
gmail × 3
mediawiki × 3
sorting × 3
importxml × 3
google-analytics × 2
search-engine × 2
text-formatting × 2
google-sheets-filter × 2
google-sheets-data-validation × 2