Pulling through hyperlinks from referenced cells

Hello

My first post, but I don't seem to be able to find this in the forums.

I have a multi-sheet workbook with one sheet containing 'friendly' text with URL hyperlinks. The text is pulled though onto various other worksheets by several formulae and I'm trying to find a way to have the hyperlink carried across into the referencing cell as well.

There doesn't seem an obvious way I can find to do this without VBA, which I'd like to avoid if I can.

Can anyone offer advice on this?

Thanks
Ben

Thanks. I believe that works only when the text displayed in the cell is the same as the hyperlink itself. In this case, the hyperlinks are long and not particularly friendly, so that's causing a bit of an issue, as only the 'friendly' text is pulled through...

Originally Posted by ben_hensel

Can you post an example spreadsheet containing the "friendly" text?

I don't know whether you'll need text processing, or can just wrap the HYPERLINK() function, or what.

I've tired to post the examples I have for this, but I get blocked by the site's proxy because it seems to think the formulae contain HTML code, which they don't!

So...here's an example of the referenced cell:
=HYPERLINK("https://en.wikipedia.org/wiki/System_Center_Configuration_Manager","SCCM")

I want to reference that from another cell with a formula that returns SCCM as the contents, displayed as a clickable link to that address.

Thanks
Ben