The answer is to use Control+Option+Enter, which will create a line break in the cell. As an alternative, Control+Command+Enter can also be used to achieve the same. These combinations work both in Excel for Mac 2011 and the new Excel for Mac 2015.
Posted:, 08:46 PM On 8/1/07 3:17 PM, in article, '[email protected]' wrote: I'm combining text from several cells into a single cell. Using the concatenate function (or the & connection), a CHAR(13) will give me a line break on the Macintosh.
However, PC users do not get a line break when they open the file. If I use CHAR(10) then it looks great for PC users, but Mac users do not get a line break! Is there an easy work around? I'm using Excel 11.3.6 on a G5 Mac under system 10.4.10.
No, there is no REAL easy work around. However you can do this with a defined name. For example, define a name Lend (or whatever you like) and in the refers to box, enter =IF(LEFT(GET.WORKSPACE(1),3)='mac',CHAR(13),CHAR(1 0)) Then in a cell you can type text as: ='Line1'&lend&'line2' Make sure the cell is 'wrapped' and it will work fine on either platform. Bob Greenblatt MVP, Macintosh bobgreenblattATmsnDOTcom. Posted:, 08:53 PM On Aug 1, 3:17 pm, [email protected] wrote: I'm combining text from several cells into a single cell.
Using the concatenate function (or the & connection), a CHAR(13) will give me a line break on the Macintosh. However, PC users do not get a line break when they open the file. If I use CHAR(10) then it looks great for PC users, but Mac users do not get a line break! Is there an easy work around? I'm using Excel 11.3.6 on a G5 Mac under system 10.4.10. You can use the INFO function to find out which OS is being used put this expression into a cell =IF(INFO('system')='mac',CHAR(13),CHAR(10)) give the cell a convenient name (eg LB, for line break) then to combine the text in A1 and A2, use =A1&LB&A2 hope it helps!
= (B5 ) - ( (B5, ( 10 ), ' )) + 1 How the formula works First, the LEN function counts total characters in the cell B5. Next SUBSTITUTE removes all 'line returns' from the text in B5 by looking for CHAR(10) which is the character code for the return character in Windows. LEN returns the result inside of a second LEN, which counts characters without carriage returns. The second count is subtracted from the first, and 1 is added to the final result, since the number of lines is the number of returns + 1. Mac version On a Mac, the code for return character is 13 instead of 10, so use this formula instead.