+ Reply to Thread
Results 1 to 7 of 7

Concatenate Long String Help Request

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    Miami
    MS-Off Ver
    2019, 365, MAC
    Posts
    45

    Concatenate Long String Help Request

    I have many times I am creating drop down lists in Excel in which I have to concatenate many cells (with a comma between them). There is always an error returned due to the length.
    Can anyone help witha formula for this? Using a separate list in another location is not an option.

    Thank you so much in advance.

  2. #2
    Forum Contributor
    Join Date
    08-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: Concatenate Long String Help Request

    May I Ask you to attach a file?

  3. #3
    Registered User
    Join Date
    12-02-2012
    Location
    Miami
    MS-Off Ver
    2019, 365, MAC
    Posts
    45

    Re: Concatenate Long String Help Request

    Thank you so much for looking. Please see attached.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    11-22-2014
    Location
    Arizona, USA
    MS-Off Ver
    Office 365
    Posts
    973

    Re: Concatenate Long String Help Request

    Can I ask for a small clarification on what you are attempting to do?
    Are you looking to make a single string out of your entire list in order to build the drop down list?
    This list, will it grow or do you expect it to remain the same length as it is now (Nearly 300 record options)?
    It seems that a list of anything more than 20 would be awfully harsh to read through(Bad setup for end user)...
    What is the end goal for this drop down menu, or functionality you are wanting to get out of this?
    Perhaps we can find another way to approach what you are using the list for to better serve those whom may look at the document.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Concatenate Long String Help Request

    Im not sure what your expected outcome is Can you provide a few samples of what you want?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  6. #6
    Registered User
    Join Date
    12-02-2012
    Location
    Miami
    MS-Off Ver
    2019, 365, MAC
    Posts
    45

    Re: Concatenate Long String Help Request

    The drop down lists are for forms. The data in each drop down may change in size and content. For example, accounts may become inactive or deleted, vendors may become inactive. The lists can potentially be quite long. The accounts would be the longest - almost 350 lines in total, though internal users can scroll to the one they need. Unfortunately, none are dependent lists, so that doesn't refine it much. Up till now, I kept concatenating on and on and on to make this happen. I was hoping there was a formula or code to help with this tricky one. Thanks again for looking.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Concatenate Long String Help Request

    Perhaps you missed this part? I need to see what your expected answers would look like, and how you arrived at them.

    Can you provide a few samples of what you want?

+ 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. Replies: 5
    Last Post: 08-28-2014, 06:01 PM
  2. String function to get selective text from long string
    By MWHLFC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2011, 02:51 PM
  3. string function to get selective text from long string
    By MWHLFC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-25-2011, 05:00 PM
  4. [SOLVED] Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a)
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2006, 11:45 AM
  5. Importing Long String - String Manipulation (EDI EANCOM 96a)
    By Brian in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2006, 08:30 AM

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