search for line break in cell
 

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!

search for line break in cell
 

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!

search for line break in cell
 

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!