View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I search and replace with a line break?

use ctrl-j instead.

But most laptops have some sort of Fn key that will make the keys act as number
pad keys.

(but ctrl-j is easier <bg.)

Impish wrote:

May well work but using a laptop

"Chip Pearson" wrote:

In the "Find What" box of the Replace dialog, hold down your left 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
(email address is on the web site)

"Impish" wrote in message
...
Want to use Ctrl-H to replace a specific character in a range of cells
with a
line break (Alt+Enter) - how do I access special characters? (^p didn't
work)





--

Dave Peterson