Remove Parts to URL

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.

Attachment 1815

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)="/"))

This single formula should do what you want...

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

Code:

---

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

---

Quote:

---

Originally Posted by snb

Code:

---

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

---

---

You forgot to remove trailing slash if there is one.