Carrier return problems within calculations

Question

Hi everyone

Carrier return problems.

I work with Numbers with Excel users, so I'm a victim of Excel.

In my calculations I'd like to make carrier returns.

As I understand it:

Numbers understands: CHAR(8232)

Exel understands: CHAR(10)

Does anyone know of a CHAR() which both applications understand?

Or

Does anyone know of a calculation, so I can save it in Excel format troublelfree.

The problem is, if I use the CHAR(8232) in an export of Excel the whole calculation is gone and only the product is left.

Any input would be helpfull.

Thanks.

Jakob

iMac, OS X Mountain Lion

Posted on Nov 5, 2012 4:01 AM

Reply

Answer 1

There are several line ending characters.

CR (Carriage Return) which is ASCII = dec 13

NL (New Line) which is ASCII = dec 10

youcould try embedding both CHAR(10) and CHAR(13)

Reply

Answer 2

Level 7

26,080 points

Numbers' CHAR function accepts numbers 32 and higher, except 127

Excel's accepts the numbers 1-127

The only solution I can think of is an error check. In Numbers, 8232 will be used. In Excel, 13 will be used:

IFERROR(CHAR(8232),CHAR(13))

Note: I used 13 instead of 10 because 10 didn't seem to do anything for me in Excel.

Reply