Creating a HyperLink

[Robin Clay]

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)) &"@xxxxxx.co.uk"

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

 

[JLatham]

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

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)) &"@xxxxxx.co.uk", 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)) &"@xxxxxx.co.uk", LEFT(A8,FIND("
",A8)-1) & "." & TRIM(RIGHT(A8,LEN(A8)-FIND(" ",A8)+1)) &"@xxxxxx.co.uk")