hard returns

[froggie]

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

 

[Pete_UK]

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

 

[RagDyer]

In the "Find What" box, enter:

<Ctrl> < J >

Leave "Replace With" blank.