Pasting list of values from excel into select list

[Justin_Larzelere]

I have a large list of values in excel that I want to copy into select list as unique values:

ex: (each line is a cell in a single column in a row):

1. Item 1
2. Item 2
3. Item 3
4. Item 4
5. Item 5
6. Item 6
7. Item 7
8. Item 8
9. Item 9
10. Item 10

I want to Copy these items into a select list as unique values.

Every time I try to copy the excel values and try to paste them into a select list, it copies over as 1 value.

Any help is appreciated.

[Scott_Collier-Weir]

Don’t use the normal select list. Instead, store these values (from your excel) as a separate table in your doc.

Then use either a relation type column (or a select list if you really want that via formula references that table).

That will be really quick for you!