+ Reply to Thread
Results 1 to 5 of 5

Converting an array to a delimited string

  1. #1
    Registered User
    Join Date
    03-17-2014
    Location
    Fort Wayne, IN
    MS-Off Ver
    Excel 2010
    Posts
    6

    Converting an array to a delimited string

    Hello all,

    I have an array that is created from column values. I want to convert the array into a delimited string. Below is the code I have which is not working when the Join function is called. Any help is appreciated.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,663

    Re: Converting an array to a delimited string

    delimStrB = Join(ArrayB,",")
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    03-17-2014
    Location
    Fort Wayne, IN
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Converting an array to a delimited string

    Quote Originally Posted by protonLeah View Post
    delimStrB = Join(ArrayB,",")
    I made the change and now get a Invalid procedure call or argument exception.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Converting an array to a delimited string

    you can't use Join with a 2d array-you've gotta transpose it
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Converting an array to a delimited string

    Hello bg819,

    Try this version...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ 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. Converting Pipe Delimited Data String into Seperate columns using VBA Macro
    By RestlessNative in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2014, 05:40 PM
  2. Converting a string to a utf8 byte array
    By technoyogi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2011, 05:06 AM
  3. converting a row of cells into a comma-delimited array and visa versa
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2010, 10:13 AM
  4. converting from a string to integer in an array
    By jerseyguy1996 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2009, 05:40 PM
  5. Covert Space Delimited string to array
    By RichardBerry in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-28-2008, 02:11 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