Chr(10) line feed and Chr(13) carriage return?

It does not support either. The CHAR function allows codes 32 to 65,525 except for 127. CHAR(10) used to work but no longer does. I guess they "fixed it". Oddly, though, it gives a different error message than CHAR(13).

You can use codes 8232 or 8233.

8232 is the unicode line separator. If you use 8232, you will need "wrap" turned on for the cell.

8232 is the unicode paragraph separator. 8233 appears to act the same as chr 10 and the same as if you used option-enter in a text string (which creates a chararcer 10). In fact, if you put it into a formula such as ='"A"&CHAR(8233)&"B" then use MID and CODE to extract the character code of the middle character, the result will be 10, not 8233. Another oddity.

EDIT: I thought I'd try out character 133, the "next line" character to see what it would do. It is within the valid range as per the formula description but it gives an error saying it is outside the range. Actually, I found that characters 128-159 don't work even though they they should. I think Apple needs to take a look at the CHAR function.

it really helps me 🙂. char(8233) <mac/numbers> == char(10) <ms/excel>

My solution to this dilemma is to Copy the character I need and Paste it into a literal string in Numbers. The literal can be incorporated in a formula by using the Concatenate operator or the Concatenate function.

Jerry

Why not use the newline character? You can type the NL by holding the <control> key while typing the <return> key