Insert Line Break into Numbers hyperlink

Question

Level 1

10 points

Insert Line Break into Numbers hyperlink

I am using the HYPERLINK formula in my Numbers table, as a way for a customer to email an order (that has been compiled). I have 4 lines of specs that I would like to be separated by line breaks, rather than 1 long line with comma's. I've seen people asking the same question, and even one said he found a solution but it was on the iPad (I'm on an iMac), and he didn't post his formula.

This is what I have so far:

=HYPERLINK("mailto:name@email.com?subject=Business Card Order&body="&Table 1::A3,"Email Order")

I've tried adding Char(13), %0D%0A, and %0a commands. Numbers kept putting the %0D... as text, and the Char 13 results in errors:

And when I used Char(13) it gave me an error - "The first argument of CHAR must represent a valid character, generally between 32 and 65535."

Any help would be appreciated.

Posted on May 24, 2015 9:35 PM

Reply

Answer 1

Best reply

Jacques Rioux

Level 4

3,498 points

May 26, 2015 6:11 AM in response to Zombocom1023

Hi,

Just press the Alt and the Return keys to insert a line break.

Here's a formula as example :

=HYPERLINK("mailto:janedoe@example.com?subject=Quote Request&body="&C3&"

"&D3&"

"&E3&"

"&F3, "Get Quote")

Reply

Answer 2

Zombocom1023 Author

Level 1

10 points

May 26, 2015 7:53 PM in response to Jacques Rioux

Thank you Jacques.

May I ask you a couple of other related questions? If you need me to post them as new questions let me know.

1) I am now trying to format the body text of the email to include a row of dashes "framing" the specs - so that the email reads:

Dear customer, below is your quote:

------------------------------

Size:

Stock:

Color:

Finishing:

Cost:

------------------------------

The only way I have been able to make this work is to use "CHAR" function 45 (repeated 30 times). It has completely bogged down that particular cell/formula to a near halt. Is there another (more efficient way) to add a row of dashes in the body text of hyperlink code? I tried using "--------" but it kept erroring out.

2) I have a separate sheet that has a list of names (in column A). I am using the checkbox (in, say, column B) to identify which names I need to print (it usually will be about 3-5 names at a time). Is there a formula that will look down the entire column of checkboxes, and whatever rows have the checkmark checked off will then list the names of the person (found in column A) or even the row number they are found? I am familiar with VLOOKUP, COUNTIF, and MATCH formulas, but I can't crack the code necessary to pull it all together. I know I could add a column of assigned letters or numbers and use Index. Match - but I need to be able to create new rows of names and don't want to have to add the correct character in the correct sequence. This will be a dynamic list - always being updated (adding and subtracting) - so I'm hoping to use the row numbers or names in column A).

Thanks in advance.

Reply

Answer 3

Zombocom1023 Author

Level 1

10 points

May 26, 2015 8:10 PM in response to Zombocom1023

Nevermind Question #1. I figured that out!

Reply