View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robin Clay Robin Clay is offline
external usenet poster
 
Posts: 17
Default 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