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

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

On Jul 14, 12:34 am, Michael Conroy
wrote:
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

Alternative to Alt + 0010 is CTRL + j


Gord Dibben MS Excel MVP

On Fri, 13 Jul 2007 16:34:01 -0700, Michael Conroy
wrote:

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.

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.



Michael Conroy wrote:

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

--

Dave Peterson