Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenated Text as a Hyperlink
Hi,
I wonder if anyone could help me? I'm trying to create a formula that will create a hyperlink which when clicked will create an email with a url in the subject line that I will collect from another part of the spreadhseet, I've started creating the formula: =CONCATENATE("mailto:",L2) On my worksheet L2 is a valid email address, but not even this is working. How can I convert the concatonated text into a hyperlink? Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenated Text as a Hyperlink
Hi,
try =HYPERLINK(L2&";") "Bishopsgate3466" wrote: Hi, I wonder if anyone could help me? I'm trying to create a formula that will create a hyperlink which when clicked will create an email with a url in the subject line that I will collect from another part of the spreadhseet, I've started creating the formula: =CONCATENATE("mailto:",L2) On my worksheet L2 is a valid email address, but not even this is working. How can I convert the concatonated text into a hyperlink? Can anyone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenated Text as a Hyperlink
With the email address in A1, the subject in A2 and the body in A3:
=HYPERLINK("Mailto:"&A1&"?subject="&A2&"&body="&A3 ,"click me") If you don't have the body of the message, just leave that portion off: =HYPERLINK("Mailto:"&A1&"?subject="&A2,"click me") or even: =HYPERLINK("Mailto:"&A1,"click me") Bishopsgate3466 wrote: Hi, I wonder if anyone could help me? I'm trying to create a formula that will create a hyperlink which when clicked will create an email with a url in the subject line that I will collect from another part of the spreadhseet, I've started creating the formula: =CONCATENATE("mailto:",L2) On my worksheet L2 is a valid email address, but not even this is working. How can I convert the concatonated text into a hyperlink? Can anyone help? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
How do I convert a text array to a concatenated text cell? Excel. | Excel Worksheet Functions | |||
Use concatenated text as name in formulas | Excel Worksheet Functions | |||
mix font styles in concatenated text | Excel Worksheet Functions | |||
concatenated text to formula | Excel Discussion (Misc queries) |