At the moment it just imports whatever I have into the excel field as a new option on the picklist, overwriting whatever was previously selected.

You can do this with a simple find replace.

Your items need to be semi-colon separated.

There is no join function in Excel for a range of cells, but with a bit of formula work and IFs you can use the CONCATENATE function to achieve this (only applicable if your multi-picklist values in excel are in different cells).

You need to join your new values with the existing ones in that picklist.

The way I usually accomplish this is create a dummy column at the end containing my new values already formatted with semicolons.

Then I use a formula to combine the connector data column and this new values column in yet another column.

Then I copy my newest result column and do edit-paste special-values into the data column replacing the old with the combination of old and new.

Whenever I work with the connector I almost always have to do data processing first with formulas.

For each name, I need an output the CONCATENATEs the name of the column if there is an X in that column, seperated with semicolons.

I can then map that value to the associated multiselect picklist in Salesforce.

A B C Desired Output Name X X A;B Name2 X X X A;B;C Name3 X X A;C I really do appreciate any help you can give, Tim September 23, 2010 Like 0 Dislike 0.

SUBSTITUTE(CONCATENATE(IF(B2X,A;,)IF(C2X,B;,)IF(D2X,C;,),.),;.,) March 20, 2018 Like 0 Dislike 0.

Unfortunately the multi-select picklist field popup support is only available for Windows.

Create Picklist In Excel For Mac