Results 1 to 5 of 5

Thread: Concatenate Multiple Lookup Values in Single Cell

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 02-16-2012, 08:14 AM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    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)
    Reply With Quote Reply With Quote
  2. 02-16-2012, 09:56 AM #2
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    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.
    Reply With Quote Reply With Quote
  3. 02-18-2012, 08:26 AM #3
    Nishant Choudhary
    Nishant Choudhary is offline
    Junior Member
    Join Date
    Sep 2011
    Posts
    8
    Rep Power
    0

    excel fox rocks

    excel fox rocks
    Reply With Quote Reply With Quote
  4. 04-03-2012, 09:43 PM #4
    jnault
    jnault is offline
    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?
    Reply With Quote Reply With Quote
  5. 04-06-2012, 09:07 PM #5
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    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)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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. Lookup Data From Multiple Sheets To Single Sheet Consolidated View Using Formula
    By Redwhite in forum Excel Help
    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

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
  •  

Forum Rules