As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Day: 1 of 365, 364 left
Tools: SharePoint Online; Excel 2013
Description: How to replace the id hashtag in the exported file from SharePoint (Term Store / Managed Metadata Columns)



Today I’ll address a pet hate of mine: Exporting a spreadsheet from a list or library in SharePoint which includes metadata from a Managed Metadata Column (Term Store). As you know, it exports the data with an id number and hashtag (#) as a prefix.

To clean this up fast – select the column, use the shortcut for replace (CTRL+H), enter “*#” in the “Find What” field (without the quotes). Leave the “Replace With” field blank. It will replace all hashtags and everything that precedes them with “nothing”. See image below to illustrate:

Note: Do not use this if the column is a multiple selection column, as SharePoint will build the multiple options as a string, which means the string will have multiple hashtags in it.
Replace hastags

Voila!!! See you tomorrow.