+ Reply to Thread
Results 1 to 3 of 3

Combine multiple vertical cells into one cell formatted with line breaks, left justified

  1. #1
    Registered User
    Join Date
    09-18-2014
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    5

    Combine multiple vertical cells into one cell formatted with line breaks, left justified

    Hello!

    It would be great to find an answer to this question.

    When viewing a spreadsheet, how do you combine the contents of cells in the same column but different rows into one cell with the contents of the seperate vertical cells displayed in a vertical list, left justified.

    i.e.:

    xxxxxxx
    xxxxxxx
    xxxxxxx


    Thanks for your time!

  2. #2
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: Combine multiple vertical cells into one cell formatted with line breaks, left justifi

    If you are trying to do this with column A, row 1-5, place your cursor in A2, select the text from the formula bar (make sure it is visisble, View tab), cut, select A1, through the formula bar paste the text. After this is all done you can go to the Home tab, Alignment section and select wrap text and then adjust your column width appropriately. Then click align text left. Does this work?

  3. #3
    Registered User
    Join Date
    09-18-2014
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    5

    Re: Combine multiple vertical cells into one cell formatted with line breaks, left justifi

    I am looking for a way to automate the process and not need to copy paste (that is what I am doing currently) and not need to use the alignment button.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 08-06-2014, 08:47 AM
  2. Mconcat combining multiple cells with line breaks
    By Triscia in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-14-2014, 10:47 AM
  3. Replies: 4
    Last Post: 04-30-2013, 06:46 PM
  4. How to combine several vertical cells in one cell
    By malnahar in forum Excel General
    Replies: 7
    Last Post: 06-16-2008, 05:58 AM
  5. line breaks in formatted cells
    By johng in forum Excel General
    Replies: 0
    Last Post: 01-06-2005, 04:27 PM

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