I'm using the following function: =HYPERLINK(M7, N7)
this will take a link in M7 ad give it a friendly name from N7. That's great but I want to remove M7 and N7 and leave a text hyperlink in place of this formula.
I've seen suggestions saying to paste special and use HTML. This option is not available (been looking into this and I see no solution)
Could anyone recommend a way to achieve this?
Thanks in advance.