If you want to delete everything through the alt-enter, you could use:

Select the Range
edit|replace
what: *(ctrl-j) Asterisk, followed by ctrl-j
with: leave blank
replace all

Be careful if you have multiple alt-enters in that range.

I think it was xl2002 that enhanced the edit|find to be non-modal. (For sure,
it's in xl2003.)

But won't ctrl-f, enter
do what you want?

radellaf wrote:

I'm having trouble with F & R not finding.

I have a cell that says, for example "Thing 1", line break (Alt-enter), then
"Thing 2". Thing 2 is blue, 1 is auto, but i don't think that matters here.

I'd ideally like to, for all cells, be able to say "delete all the black
lines, keep only the blue text", but, sufficient would be:

Find the cell I described, and replace contents with "Thing 2". I can't
find any way to even have it FIND a cell where the contents have a line break.

Seems I should be able to say find <click on the cell.

---
Also, the find window is modal - is there any way to do Find next? (Ctrl-G
in most other apps) without the big find window open and keeping you from
editing what it found.

--

Dave Peterson