Replacing Wierd Charactures

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
The line feed character has a code of 10. To enter this into the Find
What box of the Find/Replace dialogue, you need to hold down the Alt
key and type 010 on the numeric keypad. You might want to replace it
with a space.

Hope this helps.

Pete
 
If that user is using alt-enters for those linefeeds, then using ctrl-j in the
"find what" box will work--as well as Pete's (from the UK) suggestion.
 
Back
Top