View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Replace Line Feed

I like that, too. Much easier to explain over the phone.

Chip Pearson wrote:

Use ctrl-j instead of alt-0010


I never knew that . Pretty cool.

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

"Dave Peterson" wrote in message
...
Even neater...

Use ctrl-j instead of alt-0010 (easier to describe and easier
to do!)

Gary''s Student wrote:

Here is a neat trick:

Use Find/Replace, but in the FindWhat field, hold down the ALT
key type 010
and then release the ALT key. Enter your normal character in
the Replace
field.

You can use this trick to replace a variety of non-type-able
characters.
--
Gary''s Student

"nsv" wrote:


If you format a cell to wrap text, you can artificially put
in a Line
Feed with ALT+ENTER. I you format back to unwrap, the Line
Feed command
is shown as a square.

I have a spread sheet with a lot of Line Feeds, and I want
them
replaced with semicolons, but they are quite elusive and I
cannot eg.
put them into the search and replace function.

Anyone has a hint?


NSV


--
nsv
------------------------------------------------------------------------
nsv's Profile:
http://www.excelforum.com/member.php...o&userid=26500
View this thread:
http://www.excelforum.com/showthread...hreadid=513147



--

Dave Peterson


--

Dave Peterson