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.
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
1. Type all the text you want into the cell.
2. Using the formula bar, select the texts you want to look like hyperlinks and format them accordingly
3. Create as many shapes (rectangles) as links you have in the cell and put each shape over (covering) each of the hyperlinks.
4. Right-click on the first shape, and select "Link" from the menu. Add the URL accordingly and click "OK"
5. Repeat step 4 for the rest of the shapes.
6. Select all shapes at once and format them so they have "No fill" and "No outline border". That way they will be completely transparent and the texts behind them are shown.
I hope that makes sense!
Best,
- My pleasure
- Thanks again Ricardo
Procedure works fine.
br Peter