Hi,

I need to search for line breaks in multi-line cell contents and replace
them with something else (e.g., line breaks + 4 spaces). Search & Replace
feature won't accept line breaks with cut&paste.

How can I search for line breaks in multi-line cell contents? (Is there a
control key combination I can search for?)

Thanks!

In the Replace What box, hold down the ALT key and type 0010 on
the numeric keypad (not the number keys above the letters).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"cellardoor2003" wrote
in message
...
Hi,

I need to search for line breaks in multi-line cell contents
and replace
them with something else (e.g., line breaks + 4 spaces). Search
& Replace
feature won't accept line breaks with cut&paste.

How can I search for line breaks in multi-line cell contents?
(Is there a
control key combination I can search for?)

Thanks!

EditReplace

what: hold ALT key and type in 0010 from the NumPad

with: hold ALT key and type in 0010 and hit space bar 4 times

Replace all.

Gord Dibben Excel MVP

On Tue, 10 Aug 2004 16:25:04 -0700, "cellardoor2003"
wrote:

Hi,

I need to search for line breaks in multi-line cell contents and replace
them with something else (e.g., line breaks + 4 spaces). Search & Replace
feature won't accept line breaks with cut&paste.

How can I search for line breaks in multi-line cell contents? (Is there a
control key combination I can search for?)

Thanks!