Curious Hyperlinks

In the excel file attaches, you will find 3 hyperlinks. However, the first 2 are curious. They show respectively "jan-13" and "12", but these strings are NOT the TextToDisplay. For these 2 hyperlinks the TextToDisplay is empty (or ""). The third hyperlink show a correct TextToDisplay "Nieuwe ontwikkelingen".
I have 2 questions:
1) What are the string shown in the first 2 hyperlinks?
2) How can I convert these 2 to correct hyperlinks? (Preferable in VBA)

Kind reagrds

Jan Lichtenbelt

Dear Ron,

I want to remove the hypelink into the text show as is. In the original excel file it is not just one cell but a (large) column.
CAn you help me with a VBA for both colums 1 (or 2) and 3?

Kind regards

Jan Lichtenbelt

Dear Ron,

The macro helps transforms the original hyperlink cells into new hyperlink cells with only the address.

What I want is that the original cells will be transformed in strings with the content equal to what you see in the owrksheet. That means to be transformed respectively into jan-13 12 nieuwe ontwikkelingen ( see attached file on row 2)

Instead of 3 strings the format may also be respectively date number and string.

Kind regards

Jan

Although I'm still interested in the VBA code, I found a solution in the worksheet. Just select the applicable cells and delete the hyperlink. The top text remains, as wanted.

Jan Lichtenbelt