How to add a newline character in a Numbers formula

Enter a return in a numbers formula. I have a simple formula that I want to display as shown. How do I get the formula to enter a [return] after each group?

Table 2::C1 & " "& Table 2::C2 & <-- Enter a return



Table 2::D1 & " "& Table 2::D2 & <-- Enter a return



Table 2::E1 & " "& Table 2::E2 & <-- Enter a return



Table 2::F1 & " "& Table 2::F2



Is this possible? When highlighted (as you can see) there are returned entered. But I just get a long run-on sentence.


Thanks in advance.

Posted on Nov 17, 2025 3:18 PM

Reply
Question marked as Top-ranking reply

Posted on Nov 17, 2025 6:35 PM

I found the solution.


Table 2::C1 & " "& Table 2::C2 &"


"& " "&"


"& Table 2::D1 & " "& Table 2::D2 &"


"& " "&" 


"&Table 2::E1 & " "& Table 2::E2 &"


"& " "&" 
"

&Table 2::F1 & " "& Table 2::F2

1 reply

How to add a newline character in a Numbers formula

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