Add Email Link into cell content

healey21

Well-known Member
Joined
Dec 22, 2009
Messages
900
I have a cell which is merged and wrapped within the cell I have an email address and would like to be able to click the email address and send an email to the person listed. When I edit the cell which has some other text I cannot seem to set a hyperlink is there a method to do this?

Sample would be

Within each sheet you will find a list of the functions and functionality. There will be sample data and comments in cells.
You can find that most comments are being displayed on the worksheets.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:eek:ffice:eek:ffice" /><o:p></o:p>
This is an example workbook that has been designed by the Training team who can be contacted via the following email address:
Email: myaddress@hotmail.com 'This shows an email address as a link here but not in the cell
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

healey21

Well-known Member
Joined
Dec 22, 2009
Messages
900
Thanks Adrew I am sure I can alter this to use a single cell for the email address.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,519
Messages
5,596,635
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

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.
Go back
Top