Results 1 to 8 of 8

Combine 2 cells with line breaks in each of them and keep line break formatting?

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2014
    Location
    new york
    MS-Off Ver
    13
    Posts
    4

    Combine 2 cells with line breaks in each of them and keep line break formatting?

    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
    1
    First Name:
    Last Name:
    Address:
    John
    Smith
    123 Harold Street
    First Name: John
    Last Name: Smith
    Address: 123 Harold Street


    Thank you very much!
    Last edited by stoneperfor; 08-05-2014 at 08:54 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 02-19-2014, 03:49 PM
  2. Difficulty creating a basic line chart without breaks in line plots
    By brharrii in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 04-05-2013, 04:29 PM
  3. Replies: 1
    Last Post: 03-16-2013, 03:58 PM
  4. Line Chart Question - break in line for blank cells
    By JonPugh in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 12-09-2009, 09:39 AM
  5. How do I get a line break when using a formula to combine cells
    By TESA0_4 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-13-2006, 10:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1