A
AFSSkier
I have a refreshable spreadsheet with data imported from Access. When the
data imports, I get Access formatting codes like <div>,   and font codes
(see below). I doing want the end user to have to do a search & replace a
blank, even with a macro. It only happens with memo/comment fields coming
from Access.
<div><font face=Arial size=2 color="#006666">PBA data. (ALL VERSIONS
INCLUDING MONTANA)</font></div> <div> </div>
In an adjacent cell I want to use a function(s) to format the new cell to
look like this => PBA data. ;(ALL VERSIONS INCLUDING MONTANA)
data imports, I get Access formatting codes like <div>,   and font codes
(see below). I doing want the end user to have to do a search & replace a
blank, even with a macro. It only happens with memo/comment fields coming
from Access.
<div><font face=Arial size=2 color="#006666">PBA data. (ALL VERSIONS
INCLUDING MONTANA)</font></div> <div> </div>
In an adjacent cell I want to use a function(s) to format the new cell to
look like this => PBA data. ;(ALL VERSIONS INCLUDING MONTANA)