11-20-2009 05:07 AM
11-21-2009 05:44 PM
Yes you should take the commas out so that you just have the list items as you would like them
inserted. In Excel populate your list starting in A1 heading downward A2,A3,...
In B1 type this formula: =Concatenate("#",A1,"#") and drag the lower right cell corner down to the
bottom of your list. Click on the entire B column to select it, type Control C then Edit > Paste Special.
Select Values only then click OK. Select the A column and delete it. Save the file as .CSV. Open the
file with a text editor like Notepad, GVIM, or Notepad++ and replace the # with ". Save that file. Use that
file to import for the dropdown.
I also used Open Office 3.1 saved the list as CSV and didn't have to do any of the editing as it saved
properly with double quotes.
The trick is looking at the file with a text editor to verify that all looks properly delimited with double quotes
before doing the import.