-4

I have this content in a cell and I would like to extract just the word overview in this case, but could be any work between / and ?. What's the best way for that?

/overview?breakdownDimensionId=none&endDate=2019-11-04&startDate=2019-11-04&viewByDimensionId=campaign
GabrielOy
  • 3
  • 1

2 Answers2

0

try like this:

=REGEXEXTRACT(A1; "overview")

0

UPDATE:

=REGEXEXTRACT(A1; "/(.+)\?")

0

Community
  • 1
  • 1
player0
  • 124,011
  • 12
  • 67
  • 124
0

Without regex, and without knowing which word is between / and ?:

=right(LEFT(A1, SEARCH("~?",A1)-1),len(LEFT(A1, SEARCH("~?",A1)-1))-1)
Jack Fleeting
  • 24,385
  • 6
  • 23
  • 45