How do I line break after combining two cell in numbers

SUppose I have two cells A1 and B1. In C1 I combine them both using =A1&B1.

What should i add to make a line break inbetween them?

Example:

A1 = Crayon

B2 = 5.99

Using =A1&B1,

Crayon5.99

I need it to be:

Crayon

5.99

MacBook Pro 13″, macOS 15.3

Posted on Apr 8, 2025 3:20 PM

Similar questions

Format a Numbers sum cell? I cannot get Numbers to format a cell the way I want. The cell is the sum of the two cells immediately above. The two cells that I am adding each has two decimal places. But the sum cell has three decimal places. I am in Inspector > Cell > Data Format. In that format command I have set the sum cell to two decimal places. But Numbers refuses to change the sum cell to two decimal places. I am in Numbers version 13.0 (7036.0.126). Can Numbers format a cell that is the sum of two other cells?
704 1
Apple Numbers for macOS - Merge cells but only horizontally I have a Apple Numbers project sheet with over 2000 rows. The contents of column B and C should both be in column B, so we need to merge the C with B. If I just select all 4000 cells and click on "Merge cells" everything merges into one giant cell, but we only want to merge cells horizontally. How do we do this?
1307 2

2 replies

Yellowbox

Level 7

21,939 points

Apr 8, 2025 4:39 PM in response to dandingnaicha

Hi dandingnaicha,

Option return is the line break character, but you need to enclose it in quotes in a formula:

Regards,

Ian.

Apr 28, 2025 7:37 AM in response to Yellowbox

This worked! Thank you ian!

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 do I line break after combining two cell in numbers

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