We have document library for storing assets in it. Document Library contains some of Managed Metadata lookup fields. When I try to use the Ribbon feature to export the list into an Excel, each of the Managd Metadata field values has an id hash tag along with it.
Data in the excel file gets exported for Taxonomy Managed Metadata lookup fields along with their unique # tag in front of the value as like "72;#AccepatbleUse"
This makes the excel sheet very much useless and unreadable.
Has anyone tried or come across this issue in SharePoint 2010 platform and how to export the data into an Excel without the id # tags.
Is there any OOB way to fix this issue? Thanks in Advance.