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? |
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) |