+ Reply to Thread
Results 1 to 6 of 6

how to get concatenate data in a cell to arrange vertically

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    19

    how to get concatenate data in a cell to arrange vertically

    Hello

    Have asked this in another excel forum but can't seem to get an answer.
    I have a ss with action points along a single row which i can get to join up in one cell.

    my problem is can the text from each cell be arranged vertically as a separate line rather than horizontally?

    turn
    text from first cell text from second cell text from third cell

    into
    text from first cell
    text from second cell
    text from third cell

    using excel 2010

    skinpup
    Attached Files Attached Files

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: how to get concatenate data in a cell to arrange vertically

    If you have data in A1 thru C1, in another cell enter:

    =A1 & CHAR(10) & B1 & CHAR(10) & C1 and set the alignment of this cell to wrap.
    Gary's Student

  3. #3
    Registered User
    Join Date
    09-21-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: how to get concatenate data in a cell to arrange vertically

    cheers gary

    i have added the formula suggested but it doesn't put a line break between the data collected from each cell?

    what am i doing wrongarrange vertical .xlsx?

  4. #4
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: how to get concatenate data in a cell to arrange vertically

    Strange......when I open your sheet, cell AC3 does appear as a vertical list!

  5. #5
    Registered User
    Join Date
    09-21-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: how to get concatenate data in a cell to arrange vertically

    aaaaarrrgggghhhh

    sorry got so many different versions of excel open on different virtual machines i was on mac 2011 excel.

    thanks for the reply and confirming i'm not going mental! knew that formula should work, just couldn't see why!

    skinpup

  6. #6
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: how to get concatenate data in a cell to arrange vertically

    Persistence always perseveres.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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