yes, for displayed_text, enter a series of strings separated by CHAR(10) to
create a new line within the same cell. Also, and very important, format the
cell with Wrap Text (menu Format Cell, tab Alignement):
"A" & CHAR(10) & "B"
returns:
A
B
within a single cell.
So, within the HYPERLINK formula:
=HYPERLINK("mailto:" & ", "A"&CHAR(10)&"B")
would show:
A
B
highlighted as a hyperlink.
Regards,
Sebastien
"ibrettferguson" wrote:
Is there a way to insert carriage returns in the HYPERLINK formula?
For instance, in the mailto, I want the body to be:
Top line
Middle line
Bottom line
"sebastienm" wrote:
Hi,
You can use the HYPERLINK(url, displayed_text) formula, but it would have to
be in another column:
=HYPERLINK("mailto:" & ", "mail " & Q13 & " " & R13)
Would that work for you?
Regards,
Sebastien
"mtkatrev" wrote:
I'd like to take names from a list in excel and create email addresses from
them. For example:
Associate Name:
Tom Smith
If "Tom" is in one cell (Q13) and "Smith" is in the next (R13) I can compose
an email address in cell S13 with ". I'd then like to
set up a hyperlink in cell Q13 that refers to cell S13 that contains
.