Cleaning up data -- any way to globally fix this??
<BFlamingo Cookie Jar</B<BRMade of porcelain and measures Body 6" x
7" With Lid and tail 10"x11"
gets converted to this in either a CSV worksheet or an XLS worksheet:
Flamingo Cookie JarMade of porcelain and measures Body 6" x 7" With
Lid and tail 10"x11"
The <BR gets eliminated between the heading and the description which
causes two words to be 'stuck' together.
Spell checking finds them -- but, there are thousands of these -- is
there any way to fix this automatically?? (I don't have access to the
source data.)
Thanks.
Barb
|