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
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.