Interesting idea. Probably not. But, you could use an Event (Say Before_Doubleclick) to call up an option screen or Userform for two links. Would have to think about how that would work.
Or rather, you can *display* two just fine =HYPERLINK("mailto: address@somewhere.com")&REPT(" ",5)&HYPERLINK("mailto: anotheraddress@somewhereelse.com")...you just can't have the implied functionality, as clicking anywhere on the cell will fire both.
You'd need to use a workaround, such as the Userform suggestion lenze suggests above.
No, not natively. While I am sure one can cobble up a solution using VBA code, the important question is "Why?" Is there a reason whoever asked you is trying to save using another cell? It's hard to believe they are running short of cells given that a *single* worksheet can contain 65,536*256 of them.
I was asked if you could display 2 hyperlinks in 1 cell. My gut feeling tells me no but I figured I would ask the experts.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.