I am trying to merge data from two columns into one cell, with one below the other. For example, I have "1234 Main St" in column "a" and "Box 202" in column "b". I need the end result to be:
1234 Main St
Box 202
in one cell.
Thanks in advance.
I am trying to merge data from two columns into one cell, with one below the other. For example, I have "1234 Main St" in column "a" and "Box 202" in column "b". I need the end result to be:
1234 Main St
Box 202
in one cell.
Thanks in advance.
Last edited by AzDonny; 01-22-2011 at 05:47 PM.
Try
=A1&CHAR(10)&B1
Then format the cells and in Alignment Tab choose Wrap text.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks