List containing Managed Metadata when exported to Excel has weird characters?
===

I have a calendar All Events list which contains few fields, some from Managed Metadata and People presence lookup fields. When I try to use the Ribbon feature to export the list into an Excel, each of the field values have an id hash tag along with it. 

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.

For instance:
Attended by: field contains the list of Users with people presence enabled.
When I export this field value into Excel, then each User gets copied into the sheet with their own unique # tag as in Doe, John;#39 <br>
Or if it's a Taxonomy Managed Metadata lookup field, then the export data will have their unique # tag in front of the value as in 74;#Ford

Please let me know if you can help. Do ask me freely if you have any questions or need further clarifications.

One suggestion was to try to copy the value into a calculated field as simple text replacing the # tags. But I cannot create columns based off calculation from existing lookup fields. <br>
Other suggestion is to create a macro in Excel workbook Book1, which can be coded to remove these hash tags. 

I am hoping that there is some other simpler way to clean up the Excel data sheet.  Please let me know. Thanks, 