Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return value in cell above the reference | Excel Discussion (Misc queries) | |||
help with index to return particular cell value | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Return of blank cell if lookup fails | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |