Hyperlink/ text edit automation

Hi,

I have hyperlink like this.

ftp://myserver.com/mydata/data/pictures.jpg

This is in one of field and I like to change to relative link like

/mydata/data/pictures.jpg

basically, I like to get rid of first part ftp://myserver.com/ automatically.
It is because I have thousand of these data.

It takes forever to do manually.

Does anyone know automation code? VBA, tool, or something???

Thank you,
Yui Miyata

Good evening Yuimyt

Highlight all the data in the column containing this information and select Edit > Replace. In the box Find what, enter ftp://myserver.com. In the Replace with box, enter "" and click Replace All.

That should do the trick.

HTH

DominicB

Thank you so much. It worked and helped a lot after.

Yuimyt

Hi Yuimyt

Glad to help. Appreciate the feedback.

DominicB