Results 1 to 1 of 1

Thread: Method to take an ordered list and convert to a comma separated list automatically.

  1. #1
    Thread Starter
    Veteran bleem's Avatar
    Join Date
    Feb 2012
    Posts
    1,572
    Thanks
    104
    Thanked 205 Times in 180 Posts

    Method to take an ordered list and convert to a comma separated list automatically.

    Hi,

    This is going to help people enormously when creating comma separated lists from an ordered list type.

    This is workable in MS Office and possibly Open Office Calc. (I haven't used open office calc on this as I have MS Office with Excel 2010.

    It is an .xls spreadsheet with a visual basic module added (You can check this by opening the Visual Basic editor within excel and open the module to see the code) with the code to automatically convert the list to a comma separated list for use when you need to create a form full of data like states or regions for example.

    Instructions are on the worksheet itself.

    I hope you like. It saves me hours of work and I hope it will you guys too.

    If you are unsure about the file this is the code you need to add via a module to excel:


    Function csvRange(myRange As Range) csvRange = myRange csvRange = Application.Transpose(csvRange) csvRange = Join(csvRange, ",") End Function
    The function you need to use is this:

    =csvRange(I2:I16)
    Just drop your ordered list into the cell I2 and paste the function into A1 for ease.
    The comma separated list will now be in cell A1
    To get it - just right click the cell A1 and copy.

    Paste the list where ever you want.

    Attachment 4899

    Regards


    Bleem

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [MOD NEEDED] Need a drop-down list to adapt to another drop down list (Region/State)
    By retorit in forum ClassiPress General Discussion
    Replies: 3
    Last Post: October 11th, 2015, 03:03 PM
  2. UK County List instead of US List
    By untoldmedia in forum Help Using JobRoller
    Replies: 1
    Last Post: June 12th, 2012, 10:34 AM
  3. List in generic category automatically
    By philip937 in forum ClassiPress General Discussion
    Replies: 2
    Last Post: January 7th, 2012, 11:21 AM
  4. List in generic category automatically
    By philip937 in forum Report ClassiPress Bugs
    Replies: 1
    Last Post: January 7th, 2012, 09:13 AM