+ Reply to Thread
Results 1 to 2 of 2

DatavaGenerate single column array with values that contain comma?

  1. #1
    Registered User
    Join Date
    09-13-2012
    Location
    Las Vegas, USA
    MS-Off Ver
    Excel 2016
    Posts
    10

    DatavaGenerate single column array with values that contain comma?

    I started converting my data validation, dynamically pulled from SQL, from downloaded lists to arrays. This works very well unless the SQL data returned contains a comma. When I use the following code it populates the data validation with only the LastName. My workaround has been to list the names as "FirstName LastName" but is there some code that will allow populating an array with "LastName, FirstName" EG: with a list of values that contain a comma?

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: DatavaGenerate single column array with values that contain comma?

    Once you've brought the data into Excel you can probaly achieve your aim without VBA just by using functions. If you'd care to upload an example workbook that shows a before and after situation we can probably help further.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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: 3
    Last Post: 04-07-2016, 01:15 AM
  2. Replies: 2
    Last Post: 12-07-2015, 09:04 PM
  3. [SOLVED] Vlookup table array matching with multiple value in single cell separated by comma.
    By kannoy in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-04-2015, 04:03 AM
  4. [SOLVED] Using comma separated values in a single cell
    By joerobb in forum Excel General
    Replies: 7
    Last Post: 01-16-2015, 08:45 AM
  5. Count number appear in single column with comma separated
    By cheeyap91 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-29-2014, 12:38 AM
  6. Sum values based on multiple criteria (comma delimited) in a single cell
    By leem888 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-07-2011, 02:49 PM
  7. Column/cells to single cell comma separated data?
    By egeorge4 in forum Excel General
    Replies: 1
    Last Post: 04-27-2007, 03:53 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