I've been driving myself crazy trying to solve this. Im trying to combine 2 cells that both have text on multiple lines separated by line breaks. I want to keep the formatting so that when both cells are combined, line one from cell 1 and line 1 from cell 2 are on the same line in the new combined cell. This is easy to do when there is only 1 line in each cell but how do you do this for cells with multiple lines? Here is an example of what I am trying to do:
A B C 1First Name:
Last Name:
Address:John
Smith
123 Harold StreetFirst Name: John
Last Name: Smith
Address: 123 Harold Street
Thank you very much!
Bookmarks