Results 1 to 5 of 5

Thread: Concatenate Multiple Lookup Values in Single Cell

  1. #1
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10

    Lightbulb Concatenate Multiple Lookup Values in Single Cell

    Hi All,

    Here is a trick to get multiple lookup values (unique) in a single cell separated by comma.

    Enjoy !
    Attached Files Attached Files
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  2. #2
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    13
    Quote Originally Posted by Admin View Post
    Hi All,

    Here is a trick to get multiple lookup values in a single cell separated by comma.

    Enjoy !
    This is the power of Formula.
    Last edited by LalitPandey87; 02-17-2012 at 06:05 PM.

  3. #3
    Junior Member
    Join Date
    Sep 2011
    Posts
    8
    Rep Power
    0

    excel fox rocks

    excel fox rocks

  4. #4
    Junior Member
    Join Date
    Apr 2012
    Posts
    1
    Rep Power
    0

    cell max character length

    Will this concatenate only everything that will fit in a cell, truncating excess that exceeds the maximum character length for the cell?

  5. #5
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Hi

    In Excel 2007, it can concatenate a total of 32767 characters.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. LookUp Value and Concatenate All Found Results
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 48
    Last Post: 10-31-2019, 07:00 AM
  2. Loop to two columns and Concatenate values
    By ivandgreat in forum Excel Help
    Replies: 15
    Last Post: 04-14-2013, 08:20 PM
  3. Replies: 2
    Last Post: 03-21-2013, 10:38 PM
  4. Function to Concatenate Values
    By Admin in forum Download Center
    Replies: 1
    Last Post: 12-13-2012, 11:38 AM
  5. Concatenate multiple values
    By mcpizzle in forum Excel Help
    Replies: 3
    Last Post: 08-30-2012, 04:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •