Excel Export - How do you get rid of formating codes from memo fie

A

AFSSkier

When I Export to Excel, I get formating codes like <div>, &nbsp and font
codes (see below). How can I get rid of them? I don't see them in Access,
only in Excel. It only happens with memo/comment fields. I tried doing a
Format, but this only caused it to be visible in Access.

<div><font face=Arial size=2 color="#006666">PBA data. (ALL VERSIONS
INCLUDING MONTANA)</font></div> <div> </div>

I want it to format the in Excel to look like this => PBA data. ;(ALL
VERSIONS INCLUDING MONTANA)
 
Top