Carriage return

Hi Wolfgang,

The Function you are needing is CHAR, but Numbers seems to be fussy about CHAR(10). I'd swear that I've used it in the past with success, but when I try it now I'm getting the error: "The formula contains a number outside the valid range". There are simple workarounds though.

What you will do depends on how you plan to use the return character in your expression. If you are simply wanting to type multiple lines of text in a cell, go to the Table Inspector and de-select the Return Key Moves to Next Cell checkbox. Now your return key will insert a return character instead of moving the cell focus to the next cell. Uncheck the box to go back to normal operation. Another way to insert a return character is to use the Option-Return combination.

If you want to use the return character in a calculation, you can create a cell with only a return character in it and reference that cell in your expression. I've found that selecting a cell and typing 2 Option-Returns will create one return character in that cell.

Hope this gets you on track for now. Again, CHAR(10) should work, but seems to be broken.

Jerry

CHAR(8232) is the Unicode line separator character. You can use it instead of a carriage return.

If the documentation is correct, CHAR(10) should not work. The parameter must be between 32 and 65,535, not including 127. I, too, recall there was at least one number between 0 and 31 that worked, counter to the documentation, but apparently that has been "fixed".

Badunit,

I guess there's something to be said for the program behaving in accordance with the documentation, even if there seems no good reason for it. Note that if you use CODE() to expose the character code for the return character in a Numbers document you will get a 10 back.

Jerry

I was hoping for something like an H-prefix, but your suggestion certainly works. As in: ="A"&CHAR(HEX2DEC(2028))&"B"

I was just lamenting that the Special Characters Character table is in Hex while the CHAR function takes only Decimal.

Regards,

Jerry

May you look this thread:
http://discussions.apple.com/thread.jspa?messageID=10363463

in which I treated this problem. ?

Yvan KOENIG (VALLAURIS, France) mercredi 28 octobre 2009 17:33:28

Badunit,

Do you know of a way to enter the Unicodes directly as HEX in CHAR()?

Jerry

Only with the use of the HEX2DEC function.

Yvan,

What do you suppose is the reason not to allow CHAR(10) in this update of Numbers?

Jerry