How to Insert Return in Formula
I've tried to find the answer to this question in the Numbers Help and User Guide and searched in this forum but can't find the subject addressed.
I would like to concatenate several cells into one but with returns or line breaks between some of the original cells. Specifically, I want to take a table in which contact names, street addresses, cities, states and Zip codes are contained in separate cells and put this information into a cell formatted as a mailing address like this:
Name
Street Address
City, State Zip
I know how to combine the information in the individual cells into a single cell but can't solve the problem of writing a formula that causes to new cell to be a multi-line cell as shown above. Is it possible to do this in Numbers '09?
I would like to concatenate several cells into one but with returns or line breaks between some of the original cells. Specifically, I want to take a table in which contact names, street addresses, cities, states and Zip codes are contained in separate cells and put this information into a cell formatted as a mailing address like this:
Name
Street Address
City, State Zip
I know how to combine the information in the individual cells into a single cell but can't solve the problem of writing a formula that causes to new cell to be a multi-line cell as shown above. Is it possible to do this in Numbers '09?
20-inch mid-2007 iMac / White MacBook, Mac OS X (10.6.7)
