'RegexReplace in GoogleSheets To Find Multiple Strings
I have a string such as the following
bells<[email protected]>,bars<[email protected]>, ballots<[email protected]>
I would like to extract the e-mail addresses out of this string comma separated
Formula using is the following
=REGEXREPLACE(A7,"\<(.*?)\>","")
However, the results I get are the following and opposite of what I was expecting
bells,bars, ballots
This formula =REGEXEXTRACT(A7,"\<(.*?)\>") results in [email protected] just fine, but I want to get all three 3 instances.
Any help and explanation as to why the regex "<(.*?)>" isn't working.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
