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:
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
Reply With Quote