Hi,
I want to clean a worksheet with multiple lists of urls. Those urls have some strings at the beginning and at the end.
For exemple:
sdab588dddhttp://www.url1.com/page.php&sa=qsd554/ds4d
dab588dddhttp://www.url2.com/index.html&sa=fffsdf?result=4
dab588dddhttps://www.urlx.com/&sa=dfdf/5454?fdfd&id=24
...
Black = url to keep
Red = strings to remove
Important :
Thanks!
I want to clean a worksheet with multiple lists of urls. Those urls have some strings at the beginning and at the end.
For exemple:
sdab588dddhttp://www.url1.com/page.php&sa=qsd554/ds4d
dab588dddhttp://www.url2.com/index.html&sa=fffsdf?result=4
dab588dddhttps://www.urlx.com/&sa=dfdf/5454?fdfd&id=24
...
Black = url to keep
Red = strings to remove
Important :
- Every strings to remove after urls always start with &sa=
- Some urls start with https, so take care!
- I want a "click and cleanup" solution with VBA, not a formula
- The number of columns is variable
- Do not create any new columns with cleaned urls, but simply erase unwanted strings.
Thanks!