software

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: www.excelforum.com/member.php...oamp;userid=26500
View this thread: www.excelforum.com/showthread...hreadid=513147Here 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 Studentquot;nsvquot; wrote:

gt;
gt; If you format a cell to wrap text, you can artificially put in a Line
gt; Feed with ALT ENTER. I you format back to unwrap, the Line Feed command
gt; is shown as a square.
gt;
gt; I have a spread sheet with a lot of Line Feeds, and I want them
gt; replaced with semicolons, but they are quite elusive and I cannot eg.
gt; put them into the search and replace function.
gt;
gt; Anyone has a hint?
gt;
gt;
gt; NSV
gt;
gt;
gt; --
gt; nsv
gt; ------------------------------------------------------------------------
gt; nsv's Profile: www.excelforum.com/member.php...oamp;userid=26500
gt; View this thread: www.excelforum.com/showthread...hreadid=513147
gt;
gt;

If you prefer a formula method, as opposed to the cool method Gary describes,
you can use this formula. The example assumes the value containing the line
feeds is in cell A1

=SUBSTITUTE(A1,CHAR(10),quot;;quot;)
--
Kevin Backmannquot;nsvquot; wrote:

gt;
gt; If you format a cell to wrap text, you can artificially put in a Line
gt; Feed with ALT ENTER. I you format back to unwrap, the Line Feed command
gt; is shown as a square.
gt;
gt; I have a spread sheet with a lot of Line Feeds, and I want them
gt; replaced with semicolons, but they are quite elusive and I cannot eg.
gt; put them into the search and replace function.
gt;
gt; Anyone has a hint?
gt;
gt;
gt; NSV
gt;
gt;
gt; --
gt; nsv
gt; ------------------------------------------------------------------------
gt; nsv's Profile: www.excelforum.com/member.php...oamp;userid=26500
gt; View this thread: www.excelforum.com/showthread...hreadid=513147
gt;
gt;

Even neater...

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

Gary''s Student wrote:
gt;
gt; Here is a neat trick:
gt;
gt; Use Find/Replace, but in the FindWhat field, hold down the ALT key type 010
gt; and then release the ALT key. Enter your normal character in the Replace
gt; field.
gt;
gt; You can use this trick to replace a variety of non-type-able characters.
gt; --
gt; Gary''s Student
gt;
gt; quot;nsvquot; wrote:
gt;
gt; gt;
gt; gt; If you format a cell to wrap text, you can artificially put in a Line
gt; gt; Feed with ALT ENTER. I you format back to unwrap, the Line Feed command
gt; gt; is shown as a square.
gt; gt;
gt; gt; I have a spread sheet with a lot of Line Feeds, and I want them
gt; gt; replaced with semicolons, but they are quite elusive and I cannot eg.
gt; gt; put them into the search and replace function.
gt; gt;
gt; gt; Anyone has a hint?
gt; gt;
gt; gt;
gt; gt; NSV
gt; gt;
gt; gt;
gt; gt; --
gt; gt; nsv
gt; gt; ------------------------------------------------------------------------
gt; gt; nsv's Profile: www.excelforum.com/member.php...oamp;userid=26500
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=513147
gt; gt;
gt; gt;

--

Dave Peterson

gt; 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
quot;Dave Petersonquot; gt; wrote in message
...
gt; Even neater...
gt;
gt; Use ctrl-j instead of alt-0010 (easier to describe and easier
gt; to do!)
gt;
gt; Gary''s Student wrote:
gt;gt;
gt;gt; Here is a neat trick:
gt;gt;
gt;gt; Use Find/Replace, but in the FindWhat field, hold down the ALT
gt;gt; key type 010
gt;gt; and then release the ALT key. Enter your normal character in
gt;gt; the Replace
gt;gt; field.
gt;gt;
gt;gt; You can use this trick to replace a variety of non-type-able
gt;gt; characters.
gt;gt; --
gt;gt; Gary''s Student
gt;gt;
gt;gt; quot;nsvquot; wrote:
gt;gt;
gt;gt; gt;
gt;gt; gt; If you format a cell to wrap text, you can artificially put
gt;gt; gt; in a Line
gt;gt; gt; Feed with ALT ENTER. I you format back to unwrap, the Line
gt;gt; gt; Feed command
gt;gt; gt; is shown as a square.
gt;gt; gt;
gt;gt; gt; I have a spread sheet with a lot of Line Feeds, and I want
gt;gt; gt; them
gt;gt; gt; replaced with semicolons, but they are quite elusive and I
gt;gt; gt; cannot eg.
gt;gt; gt; put them into the search and replace function.
gt;gt; gt;
gt;gt; gt; Anyone has a hint?
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; NSV
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; nsv
gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt; nsv's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=26500
gt;gt; gt; View this thread:
gt;gt; gt; www.excelforum.com/showthread...hreadid=513147
gt;gt; gt;
gt;gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
I like that, too. Much easier to explain over the phone.

Chip Pearson wrote:
gt;
gt; gt; Use ctrl-j instead of alt-0010
gt;
gt; I never knew that . Pretty cool.
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; Even neater...
gt; gt;
gt; gt; Use ctrl-j instead of alt-0010 (easier to describe and easier
gt; gt; to do!)
gt; gt;
gt; gt; Gary''s Student wrote:
gt; gt;gt;
gt; gt;gt; Here is a neat trick:
gt; gt;gt;
gt; gt;gt; Use Find/Replace, but in the FindWhat field, hold down the ALT
gt; gt;gt; key type 010
gt; gt;gt; and then release the ALT key. Enter your normal character in
gt; gt;gt; the Replace
gt; gt;gt; field.
gt; gt;gt;
gt; gt;gt; You can use this trick to replace a variety of non-type-able
gt; gt;gt; characters.
gt; gt;gt; --
gt; gt;gt; Gary''s Student
gt; gt;gt;
gt; gt;gt; quot;nsvquot; wrote:
gt; gt;gt;
gt; gt;gt; gt;
gt; gt;gt; gt; If you format a cell to wrap text, you can artificially put
gt; gt;gt; gt; in a Line
gt; gt;gt; gt; Feed with ALT ENTER. I you format back to unwrap, the Line
gt; gt;gt; gt; Feed command
gt; gt;gt; gt; is shown as a square.
gt; gt;gt; gt;
gt; gt;gt; gt; I have a spread sheet with a lot of Line Feeds, and I want
gt; gt;gt; gt; them
gt; gt;gt; gt; replaced with semicolons, but they are quite elusive and I
gt; gt;gt; gt; cannot eg.
gt; gt;gt; gt; put them into the search and replace function.
gt; gt;gt; gt;
gt; gt;gt; gt; Anyone has a hint?
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; NSV
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt; nsv
gt; gt;gt; gt; ------------------------------------------------------------------------
gt; gt;gt; gt; nsv's Profile:
gt; gt;gt; gt; www.excelforum.com/member.php...oamp;userid=26500
gt; gt;gt; gt; View this thread:
gt; gt;gt; gt; www.excelforum.com/showthread...hreadid=513147
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson

--

Dave Peterson


Thanks - I'm quite familiar with the ALT nnnn for writing ±, ², ³,
etc., but the 010 code was new to me. I looked in the character map for
a LF code, and didn't find anything. And also the CTRL j was quite
cool. Where did you find those codes?--
nsv
------------------------------------------------------------------------
nsv's Profile: www.excelforum.com/member.php...oamp;userid=26500
View this thread: www.excelforum.com/showthread...hreadid=513147Chip Pearson has a very nice addin that will help determine what that
character(s) is:
www.cpearson.com/excel/CellView.htm

You could also look at Windows CharMap.exe
windows start button|run|charmap and hit enter

Or
windows start button|program files|accessories|...

The ctrl-j is a hold over from before windows--the old DOS and DOS programs used
those kinds of keys.

nsv wrote:
gt;
gt; Thanks - I'm quite familiar with the ALT nnnn for writing ±, ², ³,
gt; etc., but the 010 code was new to me. I looked in the character map for
gt; a LF code, and didn't find anything. And also the CTRL j was quite
gt; cool. Where did you find those codes?
gt;
gt; --
gt; nsv
gt; ------------------------------------------------------------------------
gt; nsv's Profile: www.excelforum.com/member.php...oamp;userid=26500
gt; View this thread: www.excelforum.com/showthread...hreadid=513147

--

Dave Peterson