Forum Discussion
Solved
How to insert hyperlink in text part of non empty excel cell
Hi I wonder how to make multiple hyperlinks inside a non empty excel cell, s.t. only the urls are shown as hyperlinks – not the entire string in cell. E.g. Type in excel cell “this is a test of h...
That is actually not true. I just did more than one link within the same cell.
Watch it working in the file attached.
Thanks, this is still not what I want since entire line will be shown when you hover over. See my updated description.
What you want is not possible.
- Thanks Hans.
That was also what I suspected, so I have marked your response as best response.
Thanks anyway
PeterI don't love being told something is not possible. And, because of that, I found a workaround that I believe should work for you. It is not exactly everything within the cell... But, I believe it is good enough.
Here I attach the solution.
Does that work for you?
Best,
- Thanks, this works fine when you have only one hyperlink in cell.
I understand that having multiple hyperlinks in one cell is not possible, so in that case you need to split into multiple cells with one hyperlink in each cell.