I have a spreadsheet created by dragging a Contacts group to Numbers. Several of the contacts have multiple phone numbers (Home, cell, work, fax, etc.) and these are put in separate columns. To make the spreadsheet more compact I would like to combine them in a single cell, which I can do in a new column using the CONCAT function and adding a space between each cell reference, but I’d rather put in a carriage return so each number is on a new line in the cell. Is there a way to add a carriage return in a function like CONCAT?
—–
Robert Bailey
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Build Carriage Return In a Function?
Comments: 2 Responses to “How Do I Build Carriage Return In a Function?”
Comments Closed.
Just type Option+Return when you want to put a Return in the function. So say you want to put B2 and C2 in a single cell, each on a different line. You would want this:
B2&"
"&C2
The way you would type that is:
B, 2, &, ", Option+Return, ", &, C, 2
Wow! Didn't think it would be that straightforward. Your Numbers course is really great--thank you!