John Caines
Well-known Member
- Joined
- Aug 28, 2006
- Messages
- 1,155
- Office Version
- 2019
- Platform
- Windows
Hello All
I'm wondering is there a way to delete multiple searches in 1 go with find and replace?
Here's my example;
Say I have a list of URLs in Column A
List below (maybe 1000 URLs)
===========
https://www.bezaat.com/uae/dubai
https://www.waseet.ae/
http://www.eyoon.com/adef
http://www.bazaarye.com/
http://souq.ma7room.com/
http://kulshe.com/-4/
http://ae.advertrupee.com/ar/
https://souqbladek.com/ae/
http://dalilak4.com/
https://www.albayan.ae/
http://ae.waseet.net/ar/site/dubai/offers
http://dubaimoon.com/
==============
I want to delete all the http's like;
Some are https://www.
Some are http://www.
Some are https://
Some are http://
==============
Is it possible to use find and replace and somehow delete all 4 of these in 1 go if I select Column A?
Otherwise I have to do this 4 separate times, be great if I could do this in 1 go.
Does anyone know if this is possible in excel 2016 please, and if so, how!
I'm sure a VBA could do it (and would love a vba sheet if possible),, that said, I really wanted to know if I could just do multiple find/replace in 1 go
Here's an image just to illustrate
https://imgur.com/a/5mJRqEG
So somehow have the 4 queries all replaced with nothing in 1 go.
Hope this makes sense.
Be great if I could somehow manage this in 1 go
Yours sincerely
A very perplexed..
John Caines
I'm wondering is there a way to delete multiple searches in 1 go with find and replace?
Here's my example;
Say I have a list of URLs in Column A
List below (maybe 1000 URLs)
===========
https://www.bezaat.com/uae/dubai
https://www.waseet.ae/
http://www.eyoon.com/adef
http://www.bazaarye.com/
http://souq.ma7room.com/
http://kulshe.com/-4/
http://ae.advertrupee.com/ar/
https://souqbladek.com/ae/
http://dalilak4.com/
https://www.albayan.ae/
http://ae.waseet.net/ar/site/dubai/offers
http://dubaimoon.com/
==============
I want to delete all the http's like;
Some are https://www.
Some are http://www.
Some are https://
Some are http://
==============
Is it possible to use find and replace and somehow delete all 4 of these in 1 go if I select Column A?
Otherwise I have to do this 4 separate times, be great if I could do this in 1 go.
Does anyone know if this is possible in excel 2016 please, and if so, how!
I'm sure a VBA could do it (and would love a vba sheet if possible),, that said, I really wanted to know if I could just do multiple find/replace in 1 go
Here's an image just to illustrate
https://imgur.com/a/5mJRqEG
So somehow have the 4 queries all replaced with nothing in 1 go.
Hope this makes sense.
Be great if I could somehow manage this in 1 go
Yours sincerely
A very perplexed..
John Caines