A co-worker is using a column in his spreadsheet as a memo field. He is
typing in long lines of text and word wrapping, which is making many of his
rows about an inch high. But that is not the problem. To make it easier to
read, he is inserting a new line characture at the end of his sentences. I
want to do a find and replace and get rid of these charactures. Why, you ask?
When I import his spreadsheet into Access, the field is classified as a memo
field and the new line feature is lost; the text all runs together like one
paragraph, rather than many seperate lines. However, I am left with a box in
the text at the end of each sentence where the new line should have taken
effect. I can't get rid of the box in Access, so I would like some help doing
a find and replace in his spreadsheet before I import it. Yet I don't know
how to put the box/carrage return line feed in the find field. Any
suggestions would be greatly appreciated. Thanks.

--
Michael Conroy
Stamford, CT