How do I add a line break in a formula in a cell when using concatenate? The CHAR(10) does not work with any numbers I have tried. I have also tried the & with variations of quote " " marks without success as seen with I Works. I am using Numbers version 5.1.

use the key combination <option>+<return> between quotes to enter a new line character.

Level 1

9 points

Line break in formula in numbers 5.1

How do I add a line break in a formula in a cell when using concatenate? The CHAR(10) does not work with any numbers I have tried. I have also tried the & with variations of quote " " marks without success as seen with I Works. I am using Numbers version 5.1.

iMac, macOS High Sierra (10.13.6)

Posted on Aug 31, 2018 8:48 PM

Similar questions

i'd like to create a line break in a formula, but char 13 doesn't work Id like to create a line break in a formula, but char 13 doesn’t work. The minimum argument has to be 32. Any ideas?
646 5
How do I stop Numbers adding quotation marks when copying cell contents I am trying to generate some HTML from within Numbers. I cannot seem to copy and paste this results into any other ap because Numbers seems to be appending quotation marks Here is my formula: =CHAR(8232)&CHAR(8232)&"<!-- ! " When I see this in numbers I see two blank lines and the start of a HTML comment. OK so far. When I copy this and paste as a value into another cell within Numbers. this is what I get. OK ... but not that useful for me. When I copy and paste from numbers to any other app ... then the quotation marks are appended. If I remove the newline characters then there is no quotations appended ... only when the cell contains a new line do I see the quotation marks. Arrrgh!!! When I copy a range of cells from numbers, some with new lines ... some without, the quotation marks are appended to each cell containing new lines .. but not those cells without the new lines. How do I s top this apparent consistent inconsistency! Since Numbers does not allow char(10) (but is Excel compatible?) Is there another way to create blank lines through formulae where Numbers does not break anything! Can anybody reproduce this? Is it a bug? Thanks.
1693 4
Adding text to a value in Numbers I have a cell in Numbers which displays a value generated by a simple formula (A2 x .25). How can I edit the formula to add text before and after the value? Example: I want to add the letter X in front of 0.09375 followed by a space and F5 so it reads: X0.09375 F5
3704 2

3 replies

Aug 31, 2018 9:01 PM in response to C34sailor

use the key combination <option>+<return> between quotes to enter a new line character.

C34sailor Author

Level 1

9 points

Aug 31, 2018 9:08 PM in response to Wayne Contello

That worked, but it indented the second line in the cell.

Sep 1, 2018 7:08 AM in response to C34sailor

perhaps you could check to see if there are spaces after the new line.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Line break in formula in numbers 5.1

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up