I got the Excel table imported from some Internet Web page, the second
column represents the URL values. There is a need to get the real URL from
the cells of this column and copy it as a visible string to another
cell/column. How can we get the URL from the cell, split it and copy as a
string to another cell, is there a simple way of doing that? If I edit the
cell it shows the HyperLink.

I tried to record a macro editing the cell, selecting the URL and then
copying it as a string to the target cell, but the macro was not recorded
correctly.

Thanks,
Just D.