| 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) | |||
Threaded Mode
