hard returns
 

In a large excel document, what are some ways to find hard returns in a cell?
I have tried find/replace--shift/enter. It does not work and also "locks"up
any futher use of find replace.
thanks

hard returns
 

If you are using it within Find/Replace then you can use CTRL-J. In
other situations (eg typing into a cell) you can use Alt-Enter to
force a line feed.

Hope this helps.

Pete

On Dec 10, 7:36 pm, froggie wrote:
In a large excel document, what are some ways to find hard returns in a cell?
I have tried find/replace--shift/enter. It does not work and also "locks"up
any futher use of find replace.
thanks

hard returns
 

In the "Find What" box, enter:

<Ctrl < J

Leave "Replace With" blank.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"froggie" wrote in message
...
In a large excel document, what are some ways to find hard returns in a
cell?
I have tried find/replace--shift/enter. It does not work and also
"locks"up
any futher use of find replace.
thanks