How to transfer email hyperlink to another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an email hyperlink in cell A1. I want the same email address to
automatically go into C1 and have it be a clickable hyperlink just link A1 is.

Obvioulsy, I can formulate C1 as =A1 but the problem is that it is not a
clickable hyperlink.

Paul
PS - I am not familiar with macros.
 
How about:

=hyperlink(a1)
or
=hyperlink("mailto:" & a1)

depending on what's in A1.
 
Back
Top