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
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityI 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 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.