| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a HyperLink
Greetings !
I put my name in Call A8 = "Robin Clay" In B8 I put the formula "=LEFT(A8,FIND(" ",A8)-1) & "." & TRIM(RIGHT(A8,LEN(A8)-FIND(" ",A8)+1)) " And Voila ! There is my e-mail address ! But how can I make that into a HyperLink, so that when clicked on it will generate an e-mail addressed to me ? Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a hyperlink to a cell on a different sheet | Excel Worksheet Functions | |||
| Creating a Hyperlink from a Single Word | Links and Linking in Excel | |||
| CREATING HYPERLINK IN EXCEL | Excel Discussion (Misc queries) | |||
| Creating a hyperlink in column | Excel Discussion (Misc queries) | |||
| Creating Hyperlink in Excel to PDF document??? | Excel Discussion (Misc queries) | |||
Threaded Mode
