Forum Discussion
How to insert hyperlink in text part of non empty excel cell
That is actually not true. I just did more than one link within the same cell.
Watch it working in the file attached.
Hi, plaurits
Here I attach a file with a working solution and here I explain how I did it:
1. Right-click the cell and add the link to the website
2. Make sure the "Text to display" input is different from the "Address" input.
3. Click OK
4. Select the cell preferably using the arrows on your keyboard.
5. Go to the "Home" tab in the Ribbon
6. On the "Editing" Group. Click the dropdown of the "Clear" menu and select "Clear Formats".
7. Using the formula bar, select the text you want to display as a hyperlink and format it as desired using the commands in the "Font" group within the "Home" tab.
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,
