try this small UDF:
Function hyp2(r As Range) As String
hyp2 = Split(r.Hyperlinks(1).Address, ":")(1)
End Function
--
Gary''s Student - gsnu2007b
"Darin Kramer" wrote:
Hi there,
In cell A1 if have "John Smith"
This is a hyperlink with the mail to function so that when you click on
cell A1 it generates an email with John Smiths Email address eg
Problem - I want to see in B1 (ie splitting the hyperlink
back to its original form) What formulae can I put in B1 to see the
actual mail address in A1?
Thanks guys!!!
Regards
D
*** Sent via Developersdex http://www.developersdex.com ***