search for line break in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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


in message
news:D[email protected]...
 
Edit>Replace

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
 
Back
Top