Results 1 to 4 of 4

Combining Multiple cells data into 1 cell

Threaded View

fitkhan Combining Multiple cells data... 10-07-2014, 04:19 PM
Richard Buttrey Re: Combining Multiple cells... 10-07-2014, 04:40 PM
fitkhan Re: Combining Multiple cells... 10-07-2014, 05:30 PM
Richard Buttrey Re: Combining Multiple cells... 10-07-2014, 06:33 PM
  1. #1
    Registered User
    Join Date
    04-05-2012
    Location
    KP
    MS-Off Ver
    Excel 2016
    Posts
    67

    Combining Multiple cells data into 1 cell

    Hi, Thanks for checking my thread. I have an excel sheet with Part numbers in Column A and their respective values in column B.. The problem is there are some Part numbers that have multiple values in column B and I want to combine them to 1 cell...
    Example

    Column A----------Column B
    SKU---------- Category
    123LM---------- Antennas:MC connector
    123LM---------- Antennas:2.4GHz typical WiFi:Omni-Directional
    123LM---------- Antennas:2.4GHz typical WiFi:Omni-Directional:Magnetic-mount


    I need...

    Column A----------Column B
    123LM---------- Antennas:MC connector;Antennas:2.4GHz typical WiFi:Omni-Directional;Antennas:2.4GHz typical WiFi:Omni-Directional:Magnetic-mount

    so these 3 values of 123LM are combined in 1 cell with a Semi Colon between it's 3 different values...
    There are hundreds of lines of data so it is not possible to do it manually..
    I shall be very thankful if someone solves this problem of me..
    Attached is an example sheet..

    Thanks a lot
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 06-05-2013, 08:06 AM
  2. Combining multiple cells into one text cell
    By p.keogh in forum Excel General
    Replies: 7
    Last Post: 06-12-2012, 01:41 AM
  3. Combining multiple cells in a column into one cell on top of one another?
    By stangz71 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-20-2011, 05:41 PM
  4. Combining Data in Multiple Cells
    By childofthe1980s in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2005, 09:42 AM
  5. Replies: 3
    Last Post: 02-07-2005, 01:06 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