Forum Discussion
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 Hans.
That was also what I suspected, so I have marked your response as best response.
Thanks anyway
Peter
That was also what I suspected, so I have marked your response as best response.
Thanks anyway
Peter
I 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.That is actually not true. I just did more than one link within the same cell.
Watch it working in the file attached.
Thanks, now I see in your solution (3) sheet - problem was that this sheet was not in your file from yesterday.
Could you pls. describe step by step the procedure you used?br Peter
