Multiple regex matches in Google Sheets formula

by

You can actually do this in a single formula using regexreplace to surround all the values with a capture group instead of replacing the text:

=join("",REGEXEXTRACT(A1,REGEXREPLACE(A1,"(\d-)","($1)")))

basically what it does is surround all instances of the \d- with a “capture group” then using regex extract, it neatly returns all the captures. if you want to join it back into a single string you can just use join to pack it back into a single cell:

enter image description here

More Related Contents:

  1. How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]
  2. Using positive-lookahead (?=regex) with re2
  3. Google Sheets Formula for Extracting Domain From Website?
  4. string pattern matching using perl regex [closed]
  5. Why is this regex allowing a caret?
  6. Regex to validate date formats dd/mm/YYYY, dd-mm-YYYY, dd.mm.YYYY, dd mmm YYYY, dd-mmm-YYYY, dd/mmm/YYYY, dd.mmm.YYYY with Leap Year Support
  7. Regex: ignore case sensitivity
  8. Carets in Regular Expressions
  9. What is the ultimate postal code and zip regex?
  10. Negating a backreference in Regular Expressions
  11. Regex to split HTML tags
  12. Is it possible to define a pattern and reuse it to capture multiple groups?
  13. What’s the technical reason for “lookbehind assertion MUST be fixed length” in regex?
  14. Regular expression to match last number in a string
  15. R/regex with stringi/ICU: why is a ‘+’ considered a non-[:punct:] character?
  16. Regex to match any character including new lines
  17. Regex: How to match a string that is not only numbers
  18. Regular expression for parsing name value pairs
  19. Need a regular expression – disallow all zeros
  20. How to match a line not containing a word [duplicate]
  21. How do I get regex support in Excel via a function, or custom function?
  22. How to search and replace with a counter-based expression in Vim?
  23. Combining $regex and $or operators in Mongo
  24. Case insensitive search in Mongo
  25. Why does VIM have its own regex syntax?
  26. Replace with whole match value using Notepad++ regex search and replace
  27. Regex for field that allows numbers and spaces
  28. Remove all characters before a period in a string
  29. powershell extract text between two strings
  30. Get Twitter @Username with Regex in R

Leave a Comment