Remove extraneous characters from term store data export to excel
When SharePoint data is exported to Excel, managed metadata columns show up with extra characters, such as 35;#Metals instead of just Metals. Would be better if only the term name got transferred.
I'm really wondering why in the world this hasn't been resolved yet! This is a huge pain for us and requires a lot of manual work arounds. Microsoft - please resolve!
This is definitely needed. We use Global Term store extensively to keep consistency in our data across the organization. This is taking away from this effectiveness and efficiency.
Rob Barker commented
Yes, yes, yes please!!
yes please such a pain to remove it in excel
Yes please! It's a right royal pain in the butt having to resolve this before you can present the data professionally!
Tom Burke commented
Yes. Yes. Yes.