SOLVED

hyperlinks in the same cell

Copper Contributor

Hi! I'm wondering if anyone knows how to insert more than one hyperlink in the same cell? I'm quite new on excel :) 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@oliviaj unfortunately Excel does not allow multiple links in a single cell.  

In fact, something interesting I found is you can create a Hyperlink and then 'add' to it:

 

=HYPERLINK("http://www.amazon.com","amazon")&"/deals"

 

so in the above the "hyperlink" is to amazon.com and then I add the text "/deals" to show in the cell but when you click on the link it will take you to www.amazon.com/deals 

oh no :( okey, thanks for taking your time and checking!
Got it, that's something at least!! :)
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@oliviaj unfortunately Excel does not allow multiple links in a single cell.  

In fact, something interesting I found is you can create a Hyperlink and then 'add' to it:

 

=HYPERLINK("http://www.amazon.com","amazon")&"/deals"

 

so in the above the "hyperlink" is to amazon.com and then I add the text "/deals" to show in the cell but when you click on the link it will take you to www.amazon.com/deals 

View solution in original post