| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a prefix to a cell by using a formula | Excel Discussion (Misc queries) | |||
| Extract hyperlink string from excel cell | Links and Linking in Excel | |||
| How is it that a cell can transfer the correct formula, but the w. | Excel Discussion (Misc queries) | |||
| how do I display a hyperlink in a seperate cell in excel? | Excel Discussion (Misc queries) | |||
| Is there a way to transfer a style by cell referrence in a formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
