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

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.

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.