Carriage Return within Cell for MAC users

[SAP2112]

Greetings.

For MAC Users: To concatenate a set of values in a cell with a carriage
return between each value, do the following;

- set alignment for formula cell to "Wrap Text".
- Concatenate CHAR(13) into the string.

Example: To see Bananas Oranges Apples as

Bananas
Oranges
Apples

within a cell, the formula is

="Bananas"&CHAR(13)&"Oranges"&CHAR(13)&"Apples"

This forum has the info for Windows (i.e. CHAR(10) in ANSI) but I
couldn't find it for a Mac, but the posts pointed me in the right
direction and I found it by trial and error.

Regards,
SAP2112