2 Hyperlinks into 1 Cell

  • Thread starter Thread starter infojacques
  • Start date Start date
I

infojacques

Hi,

Would anyone know how to insert the following into one cell:

My first email address:
(e-mail address removed)
Mey second email address:
second @test.test

Tthe lines 1 and 3 must be text format.
The lines 2 and 4 must be two different hyperlinks to the related
email addresses.

Thanks for your help.

Jacques
 
You get one hyperlink per cell--either via the insert|hyperlink or the
=hyperlink() worksheet function.

But you can cheat a bit.

Type your first address, then hit alt-enter (to force a new line within the
cell), then type in your second address.

Now comes the cheating part.

Show the drawing toolbar (view|toolbars|check drawing)

Carefully put a rectangle over the first address. And then put another
rectangle over the second address.

Now rightclick on the top rectangle.
Choose Format Autoshape
On the colors and lines tab, change the color of the fill to No Fill.
And change to the color of the line to No Line.
Click ok.
Rightclick on the top rectangle again and choose Hyperlink.
Type in:
mailto:[email protected]

Then do the same kind of thing for the bottom rectangle.

If you format the text within the cell to look like a hyperlink (blue text
that's underlined), it may be sufficient for you.
 
Thank you for the solution !
That will work for sure !
Have a great end of day !
Jacques
 
Back
Top