MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Build Carriage Return In a Function?

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

Comments: 2 Responses to “How Do I Build Carriage Return In a Function?”

    11 months ago

    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

    Robert Bailey
    11 months ago

    Wow! Didn't think it would be that straightforward. Your Numbers course is really great--thank you!

Leave a New Comment Related to "How Do I Build Carriage Return In a Function?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)