How to transfer email hyperlink to another cell

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.

Peepster wrote:
>
> 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.

--

Dave Peterson

Thanks Dave.
=hyperlink("mailto:" & a1) is the one that worked.
Paul


"Dave Peterson" wrote:

> How about:
>
> =hyperlink(a1)
> or
> =hyperlink("mailto:" & a1)
>
> depending on what's in A1.
>
> Peepster wrote:
> >
> > 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.
>
> --
>
> Dave Peterson
>