I've got a SharePoint Calendar that i've linked to an Excel document and it's currently pulling the data through and dumping it in a table and also a chart on another sheet (But that's irrelevant!)
When it comes into the table it's giving me some HTML Code Tags around the details like this
It also gives me some other tags sometimes such as:
<div>Change into Pre Prod </div><div> </div><div>See CHG XXXXX</div>
Does anyone know how to stop the tags coming through into excel?