Carriage Return within Cell for MAC users
 

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


--
SAP2112
------------------------------------------------------------------------
SAP2112's Profile: http://www.excelforum.com/member.php...o&userid=36006
View this thread: http://www.excelforum.com/showthread...hreadid=558677