New answers tagged regexextract
1
vote
Accepted
Regexextract numbers from string
simply add a question mark, like this:
=REGEXEXTRACT(A2,"\d+-?\d+")
you could make an array for that formula with:
=index(if(A2:A<>"",REGEXEXTRACT(A2:A,"\d+-?\d+"),...
- 768
0
votes
How to write a Google Sheets formula to extra a substring from a URL?
This is the old-school approach to this problem.
=mid(B2,len("https://www.reddit.com/r/")+1,search("/",B2,len("https://www.reddit.com/r/")+1)-len("https://www.reddit....
- 4,624
1
vote
How to write a Google Sheets formula to extra a substring from a URL?
Try with this formula in C2:
=index( regexextract(regexreplace(B2:B,"https://www.reddit.com/r/",""),"([^\/]*)"))
- 768
Top 50 recent answers are included