+ Reply to Thread
Results 1 to 5 of 5

Need to combine cells based on first cell

Hybrid View

  1. #1
    Registered User
    Join Date
    09-05-2012
    Location
    Dallas, Tx
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: Need to combine cells based on first cell

    Put this into Cell F2 and then copy it down
    =CONCATENATE(B2," ",C2," ",D2," ",E2)



    <------Please click the star if this helped you!
    http://excelevangelist.blogspot.com/

  2. #2
    Registered User
    Join Date
    02-27-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: Need to combine cells based on first cell

    Your not looking at my attached file, I can add the year make model together, look at the attached file, and you will get the idea, based off the value in column A, I want to combine the vehicles separated by a comma in one line.

  3. #3
    Registered User
    Join Date
    09-05-2012
    Location
    Dallas, Tx
    MS-Off Ver
    Excel 2007
    Posts
    88

    Re: Need to combine cells based on first cell

    This forumula is dependent on having column A sorted, like you have it in the sample.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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