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