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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With a Function, how can I get rid of formating codes like <div> ? 30
Memo format field data problem - Data import to Excel from databas 3
Memo format field data problem - Data import from Access database 0
export access memo fileds to excel 1
Exporting Excel to Access - formating text box to memo 4
How get rid of reveal codes? 4
Losing data from memo field when exporting to Excel 6
ignoring format/control codes exporting data from access to excel 21

Top