0

I have a choice field(checkbox, multiple values) in a SharePoint List. In SharePoint values are displayed as Choice1, Choice2.

When exported to Excel the format used in Excel is Choice1,#Choice2

I do not want the # to be present

  • I would like to do this inversely. What do I need to type in my Excel file to get a multiple value item in SharePoint when imported from Excel? – Fabian M Aug 28 '18 at 15:05
  • If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review – MHeld Aug 28 '18 at 20:15
3

I am not 100% sure if this should be posted as an answer or a comment (but the question doesn't include a question).

You can't get it without the #. The separator is actually ",#": a comma followed by a pound.

Independently from SharePoint, Excel does handle drop down lists (choice fields), but does NOT handle drop downs with multiple selections. When mapping Excel to SharePoint lists, Microsoft had to find something to show that this was not a standard text field, and they went for this ",#" as just a comma is too common and likely to be present in your values.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.