View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Moose The Moose is offline
external usenet poster
 
Posts: 35
Default 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