Remove Parts to URL

[waldoctg]

Also, can you make one for me to just get rid of any http://; https://; www.; http://www.; https://www.; as well as "/" at the end? Like shown in the example below.

1815

[Admin]

Hi

Welcome to board.

If the URL in A1,

in B1

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A1),"https://",""),"http://",""),"www.","")

and in C1

=LEFT(B1,LEN(B1)-(RIGHT(B1)="/"))

[Rick Rothstein]

This single formula should do what you want...

=MID(SUBSTITUTE(LEFT(A1,LEN(A1)-(RIGHT(A1)="/")),"www.",""),IFERROR(FIND("://",A1)+3,1),999)

[snb]

Sub M_snb()
Columns(1).Replace "*www.", ""
Columns(1).Replace "*://", ""
End Sub

[Rick Rothstein]

Sub M_snb()
Columns(1).Replace "*www.", ""
Columns(1).Replace "*://", ""
End Sub
You forgot to remove trailing slash if there is one.