Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

New answers tagged

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+"),...
user avatar
  • 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....
user avatar
  • 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/",""),"([^\/]*)"))
user avatar
  • 768

Top 50 recent answers are included