Format of note field

[jgowing]

Is there any way to make the notes field format nicely when the report is exported to excel? The "Body"(first note) field contains html tags that do not display correctly. Some of the tickets display correctly in the report view but others start with a <p> tag
eg:
<div> <p style="margin: 0px;">Hi Josh, </p> <p style="margin: 0px;">...

we have the following report that gives us the body of the ticket and our custom resolution and closure field:

Select Top 1000000 htblticket.ticketid,
htblticket.date As CreationDate,
htblticket.updated As LastUpdated,
htbltickettypes.typename As Type,
htblticketstates.statename As State,
htblpriorities.name As Priority,
htblsource.name As Source,
htblusers.name As [User],
htblusers1.name As AssignedAgent,
htblticket.subject,
(Select Top 1 htblnotes.note From htblnotes
Where htblnotes.ticketid = htblticket.ticketid Order By
htblticket.date) As body,
closure.data As closureID,
resolution.data As Resolution
From htblticket
Inner Join htblpriorities On htblpriorities.priority = htblticket.priority
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Left Join htblagents On htblagents.agentid = htblticket.agentid
Left Join htblusers htblusers1 On htblusers1.userid = htblagents.userid
Inner Join htbltickettypes On htblticket.tickettypeid =
htbltickettypes.tickettypeid
Inner Join htblsource On htblticket.sourceid = htblsource.sourceid
Left Join htblticketcustomfield As resolution On htblticket.ticketid =
resolution.ticketid And
resolution.fieldid = (Select htblcustomfields.fieldid From htblcustomfields
Where htblcustomfields.name = 'Ticket Resolution')
Left Join htblticketcustomfield As closure On htblticket.ticketid =
closure.ticketid And closure.fieldid = (Select htblcustomfields.fieldid
From htblcustomfields Where htblcustomfields.name = 'Closure ID')
Where htblticket.date > GetDate() - 30
Order By closure.ticketid