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
.