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

=LEFT(A8,FIND(" ",A8)-1) & "." & TRIM(RIGHT(A8,LEN(A8)-FIND(" ",A8)+1))
"

Try this, change your formula to use the Hyperlink function:
=HYPERLINK("mailto:" & LEFT(A8,FIND(" ",A8)-1) & "." &
TRIM(RIGHT(A8,LEN(A8)-FIND(" ",A8)+1)) ", A8)

That should simply echo your name in its normal format as a hyperlink to
your email. If you want to actually display the email address also, then
=HYPERLINK("mailto:" & LEFT(A8,FIND(" ",A8)-1) & "." &
TRIM(RIGHT(A8,LEN(A8)-FIND(" ",A8)+1)) ", LEFT(A8,FIND("
",A8)-1) & "." & TRIM(RIGHT(A8,LEN(A8)-FIND(" ",A8)+1)) ")



"Robin Clay" wrote:

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