Display URL's inside a text in a cell as links?

[pluginguin]

Hello,

I have some cells with text. A part of each of these texts is an URL.
But these URLs are not formatted as a link, you only see the absolute definition of the url.
I know that if a cell contains an URL only, it is formatted as a link, but how do I do that when there is more text in the same cell?

Regards,

Pluggie

 

[bobsan42]

The whole cell must be marked as a hyperlink if you want it to work as one.
So the text that will be displayed is will have to be the hyperlink's TextToDisplay.
You can however separately format each part of the text differently so the link will stand-out.
There are two ways to do it:
- manually
- automate with VBA if you have a way to discover the URL inside

 

[pluginguin]

Hello bobsan,

I see how that would work.
Since all the URLs in the file have the same beginning I would need a piece of code that finds a string that starts with that beginning and ends before the first space.
I will try and find it.

Thanks for the tip!

 

[pluginguin]

On the other hand... if I do it that way, users can not easily modify the text later (if needed) because of all the markup.

So I'm contemplating other options.
Sorry that it won't work in the single cell though...

Regards, Pluggie