Find and Replace where there are line breaks
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.
|