How To Remove Everything After website url

[tehrijack]

Hi,

I have large number of urls in following format

http://www.abcd.com/rt33.html

http://www.xyz.org/4rrr/test.html

I want to remove everything after / i.e from the above urls i want to remove /rt33.html and /4rrr/test.html so that i get the unique urls only i.e http://www.abcd.com and http://www.xyz.org.

Please help.

[GC Excel]

Hi and welcome to the forum,
Assuming all URLs start with http://, try this formula :

Please Login or Register  to view this content.

[Glenn Kennedy]

Hi. Here's one way:

=LEFT(A1,FIND(CHAR(1),SUBSTITUTE($A1,"/",CHAR(1),3))-1)

Drag down.

[tehrijack]

Thanks very much..all worked.