Re: Replace Line Feed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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?action=getinfo&userid=26500
View this thread: http://www.excelforum.com/showthread.php?threadid=513147



--

Dave Peterson
.

Relevant Pages

  • Re: Why I stop attacking HLA
    ... > Betov wrote: ... >> Propaganda trick he is much used to. ... > by and large the average student does far better when their education ... > produce a much better educational experience for that student. ...
    (alt.lang.asm)
  • Re: Tricky examiners
    ... But if the student didn't react well to the trick, ... Looking through the PTS, I don't see anything on the examiner's test ... checkride over an issue that is not required by the PTS. ...
    (rec.aviation.piloting)
  • RE: needing a keystroke for the current date AND time
    ... Sub DayTime() ... ActiveCell = Now ... It may do the trick ... Gary''s Student - gsnu200812 ...
    (microsoft.public.excel.misc)
  • Re: [CRIT] Opening
    ... it wasn't a trick or a test. ... having with that pattern?" ... less of him as a person and as a teacher because of it. ... and I don't think that discussing one student behind ...
    (rec.arts.sf.composition)
  • Re: Combine RSS Feeds in Outlook 2007
    ... That did the trick. ... Outlook 2007? ... I want to be able to see all of the feeds using ... one single explorer. ...
    (microsoft.public.outlook.general)