I already searched for formulas or add ins online but can't seem to find any formula for this.
I was wondering if I can remove everything after a question mark in a URL?
to
Thanks!
I already searched for formulas or add ins online but can't seem to find any formula for this.
I was wondering if I can remove everything after a question mark in a URL?
to
Thanks!
For a manual way, use find and replace: find: ~?* replace with: (nothing)
A comment above has the best answer: LEFT(A1,FIND("?",A1)-1)
with the -1 included.