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

How Do I Create a Two Line Result In Concatenate?

Using Concatenate to merge values from 2 cells. Know to use ” ” between sources to create spaces between the two sources, i.e. =Concatenate A3, ” “, A2 results in [Smith Hollywood].

Would like Concatenate result to look like this in the same cell:
Smith
Hollywood

Thanks

MBP Mojave 10.14.6 Numbers 10.0

—–
Kazoo2U

Comments: One Response to “How Do I Create a Two Line Result In Concatenate?”

    5 months ago

    Inside the quotes, instead of typing spaces, hold the Option key down and press the Return key. This inserts a return character instead of ending your entry. The important part is Option+Return not just Return.

    Also, instead of using the CONCATENATE function, you can just use the & symbol. So A3&” “&A2. That makes things a little easier.

Comments Closed.