Find and Replace

[kjxavier]

I have a big list of Classified websites placed in a Column eg:

http://www.classifieds.patientsville.com/publish-a-new-ad.htm/
http://www.classifieds.übertrainiert.de/index.php/
http://www.classifieds.sunsim.in/
etc
etc.....

And i want is to remove the word including . between two period (.) after the www
i.e.: i need a answer like this after a Find and Replace

http://www.patientsville.com/publish-a-new-ad.htm/
http://www.übertrainiert.de/index.php/
http://www.sunsim.in/

Is there anyway i can get a result like that!

i appreciate you fast reply.

 

[hatstand]

As you are only replacing 'classifieds.' with nothing. This will do. But if you expect classifields to appear anywhere else you will need a different find and replace.


Cells.Replace What:="classifieds.", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

 

[kjxavier]

Sorry, i didn't mention:

its not classified. always....

there are other words as well...... eg:

http://www.classifiedzone.22web.net/
http://www.canada.clubde.info/
http://www.delhi.hugeindia.in/
etc.........

 

[hatstand]

Is it the first word after 'www.' and before the next '.' that you want removed?

 

[kjxavier]

Exactly

the first word after " www. " including the next (.) after the word