+ Reply to Thread
Results 1 to 4 of 4

How to Combine Content of Adjacent Vertical Cells Into One Cell?

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

    How to Combine Content of Adjacent Vertical Cells Into One Cell?

    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?

    i.e. You have a spreadsheet with ten rows and content in columns A-F. How do I combine the content of column C in rows 7-10 into one cell.

    Thanks for your time!


    EDIT:

    I'm sorry I need to elaborate, I need the contents of the seperate vertical cells displayed in one cell, in a vertical list, left justified.

    i.e.:

    xxxxxxx
    xxxxxxx
    xxxxxxx
    Last edited by seanmc.excel; 09-18-2014 at 02:22 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: How to Combine Content of Adjacent Vertical Cells Into One Cell?

    =c7&c8&c9&c10

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: How to Combine Content of Adjacent Vertical Cells Into One Cell?

    Use the Merge and Centre command in your main menu.

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

    Re: How to Combine Content of Adjacent Vertical Cells Into One Cell?

    I'm sorry I need to elaborate, I need the contents of the seperate vertical cells displayed in one cell, in a vertical list, left justified.

    i.e.:

    xxxxxxx
    xxxxxxx
    xxxxxxx

+ 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. [SOLVED] [How] Place Horizontally Adjacent Cells in Vertical Format
    By chocochoco in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-17-2013, 06:00 PM
  2. Replies: 3
    Last Post: 05-21-2012, 03:42 AM
  3. How to combine content of multiple cells into one cell
    By friend11_6 in forum Excel General
    Replies: 3
    Last Post: 07-10-2009, 11:25 AM
  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. Counting cells with a criteria based on content and adjacent cell
    By ziggy12345 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2008, 03:32 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