none
Importing Lists from Excel RRS feed

  • Question

  • I am trying to import a list and populate it based on values in an Excel Spreadsheet. One of the columns that needs to be exported is to be selected as a multi-select choice in Sharepoint. For example, the three options are A, B, C.

    A column may have one , two , three or none of the above selected resulting in the following values ( I have a concatenate function to generate the string)

    A
    B
    C
    AB
    AC
    BC
    ABC
    <>

    When I import this list in sharepoint and set up  the list column as a multi-select choice list, All the permutations above appear as choices. But I just want A, B and C to display as the choices, so that when the user filters the list on A
    A
    AB
    AC
    ABC

    all three appear.

    Any ideas, on how to get this done???
    Tuesday, June 10, 2008 1:39 AM